From 6a8c47a0a04abe607faa96339527935f5586c80f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 11 Sep 2019 11:01:53 -0400 Subject: [PATCH] Better defined node unique constraint Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql index 3c6a75274b..dde285e762 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql @@ -20,7 +20,7 @@ CREATE TABLE elastic.node ( active BOOLEAN NOT NULL DEFAULT FALSE, cluster TEXT NOT NULL REFERENCES elastic.cluster (code) ON DELETE CASCADE, - CONSTRAINT node_once UNIQUE (host, port) + CONSTRAINT node_once UNIQUE (host, port, path, cluster) ); CREATE TABLE elastic.index ( -- 2.11.0