From 6035a5e1eaeebc75a134b6e31e4717f283ddd4d9 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 28 Apr 2016 11:27:11 -0400 Subject: [PATCH] LP#1569884: fix schema update script CREATE INDEX cannot run concurrently in a transaction block period, at least as of 9.4. Signed-off-by: Galen Charlton --- Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql b/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql index 235a5f0cb0..c403a5d27d 100644 --- a/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql +++ b/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql @@ -3,6 +3,6 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique"; -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; COMMIT; -- 2.43.2