From c3c8b74d5169ef31d9801054ddd66f0320e6591b Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Mon, 31 Mar 2014 15:59:25 -0400 Subject: [PATCH] Remove unwanted index recreation After some discussion, it was noted that this index was formally dropped eons ago. The fact we are re-dropping it in this upgrade is just a precaution, so there is no need to try to recreate it. Signed-off-by: Dan Wells --- .../src/sql/Pg/upgrade/0875.schema.authority.in-line-headings.sql | 6 ------ 1 file changed, 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0875.schema.authority.in-line-headings.sql b/Open-ILS/src/sql/Pg/upgrade/0875.schema.authority.in-line-headings.sql index 6fd43d02cc..0034fdd75b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0875.schema.authority.in-line-headings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0875.schema.authority.in-line-headings.sql @@ -41,12 +41,6 @@ ALTER FUNCTION authority.simple_heading_set(TEXT) STABLE STRICT; COMMIT; -\qecho . -\qecho This index might fail, and is outside the transaction for that reason. -\qecho If it fails, you probably did not have it in the first place. -\qecho . -CREATE UNIQUE INDEX unique_by_heading_and_thesaurus ON authority.record_entry (heading) WHERE deleted IS FALSE or deleted = FALSE; - ALTER TABLE authority.record_entry ENABLE TRIGGER a_marcxml_is_well_formed; ALTER TABLE authority.record_entry ENABLE TRIGGER aaa_auth_ingest_or_delete; ALTER TABLE authority.record_entry ENABLE TRIGGER b_maintain_901; -- 2.11.0