From 7b8ea038b983903ed5094e96a6547b19ee8def13 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 27 Apr 2016 15:43:31 -0400 Subject: [PATCH] LP#1569884 Fix two problems in previous commit. The CREATE TABLE biblio.monograph_part statement in 010.schema.biblio.sql ended up with a trailing comma. The CREATE UNIQUE INDEX on biblio.monograph_part cannot be done CONCURRENTLY at DB creation time, apparently. At least not on PostgreSQL 9.3. Signed-off-by: Jason Stephenson Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index 3312edfc7f..f0c0133a6f 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -98,9 +98,9 @@ CREATE TABLE biblio.monograph_part ( record BIGINT NOT NULL REFERENCES biblio.record_entry (id), label TEXT NOT NULL, label_sortkey TEXT NOT NULL, - deleted BOOL NOT NULL DEFAULT FALSE, + deleted BOOL NOT NULL DEFAULT FALSE ); -CREATE UNIQUE INDEX CONCURRENTLY record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE; +CREATE UNIQUE INDEX record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE; CREATE OR REPLACE FUNCTION biblio.normalize_biblio_monograph_part_sortkey () RETURNS TRIGGER AS $$ BEGIN -- 2.43.2