From 082d5ab711f0bfef8df0627571659c35c82af814 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 2 Mar 2015 21:34:53 -0500 Subject: [PATCH] LP#1205061: Add IF EXISTS to some DROP statements in 2.3-2.4 upgrade script To prevent potential issues, add IF EXISTS clauses to DROP statements in this version upgrade script. Signed-off-by: Ben Shum Signed-off-by: Jason Stephenson --- .../version-upgrade/2.3-2.4.0-upgrade-db.sql | 20 +++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0-upgrade-db.sql index 6d920296ae..475f5862cd 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4.0-upgrade-db.sql @@ -72,12 +72,12 @@ DROP VIEW IF EXISTS reporter.classic_item_list; DROP VIEW IF EXISTS metabib.full_rec; -- These indexes have to go. BEFORE we alter the tables, otherwise things take extra time when we alter the tables. -DROP INDEX metabib.metabib_author_field_entry_value_idx; -DROP INDEX metabib.metabib_identifier_field_entry_value_idx; -DROP INDEX metabib.metabib_keyword_field_entry_value_idx; -DROP INDEX metabib.metabib_series_field_entry_value_idx; -DROP INDEX metabib.metabib_subject_field_entry_value_idx; -DROP INDEX metabib.metabib_title_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_author_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_identifier_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_keyword_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_series_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_subject_field_entry_value_idx; +DROP INDEX IF EXISTS metabib.metabib_title_field_entry_value_idx; -- Now grab all of the tsvector-enabled columns and switch them to the non-wrapper version of the type. ALTER TABLE authority.full_rec ALTER COLUMN index_vector TYPE pg_catalog.tsvector; @@ -1925,7 +1925,7 @@ SELECT evergreen.upgrade_deps_block_check('0772', :eg_version); INSERT INTO config.internal_flag (name) VALUES ('ingest.metarecord_mapping.preserve_on_delete'); -- defaults to false/off -DROP RULE protect_bib_rec_delete ON biblio.record_entry; +DROP RULE IF EXISTS protect_bib_rec_delete ON biblio.record_entry; CREATE RULE protect_bib_rec_delete AS ON DELETE TO biblio.record_entry DO INSTEAD ( UPDATE biblio.record_entry @@ -2180,7 +2180,7 @@ $$ LANGUAGE PLPGSQL; SELECT evergreen.upgrade_deps_block_check('0775', :eg_version); ALTER TABLE config.z3950_attr - DROP CONSTRAINT z3950_attr_source_fkey, + DROP CONSTRAINT IF EXISTS z3950_attr_source_fkey, ADD CONSTRAINT z3950_attr_source_fkey FOREIGN KEY (source) REFERENCES config.z3950_source(name) @@ -2726,7 +2726,7 @@ ALTER TABLE vandelay.import_bib_trash_fields -- now that have values, we can make this non-null ALTER COLUMN grp SET NOT NULL, -- drop outdated constraint - DROP CONSTRAINT vand_import_bib_trash_fields_idx, + DROP CONSTRAINT IF EXISTS vand_import_bib_trash_fields_idx, -- owner is implied by the grp DROP COLUMN owner, -- make grp+field unique @@ -3022,7 +3022,7 @@ SELECT evergreen.upgrade_deps_block_check('0782', :eg_version); SELECT evergreen.upgrade_deps_block_check('0785', :eg_version); -DROP INDEX actor.prox_adj_once_idx; +DROP INDEX IF EXISTS actor.prox_adj_once_idx; CREATE UNIQUE INDEX prox_adj_once_idx ON actor.org_unit_proximity_adjustment ( COALESCE(item_circ_lib, -1), -- 2.43.2