From 640e3441efb313f537f6bf3c751fab473ce7cb0d Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Mon, 15 Jun 2015 16:29:02 -0400 Subject: [PATCH] LP 902255: Fix upgrade script. Run as-is, the upgrade script produces an error: ERROR: CREATE INDEX CONCURRENTLY cannot run inside a transaction block Following this conversation in IRC, it was decided to remove the keyword CONCURRENTLY from the create index statement. http://irc.evergreen-ils.org/evergreen/2015-06-15#i_182857 Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/upgrade/0920.schema.disallow-double-capture.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0920.schema.disallow-double-capture.sql b/Open-ILS/src/sql/Pg/upgrade/0920.schema.disallow-double-capture.sql index 3e698c2470..88f55f0570 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0920.schema.disallow-double-capture.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0920.schema.disallow-double-capture.sql @@ -2,7 +2,7 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('0920', :eg_version); -CREATE UNIQUE INDEX CONCURRENTLY +CREATE UNIQUE INDEX hold_request_capture_protect_idx ON action.hold_request (current_copy) WHERE current_copy IS NOT NULL -- sometimes null in old/bad data AND capture_time IS NOT NULL -- 2.11.0