From 9dcc7b8722f1ba92c4dc8c08fe7e6c08e2ee7906 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 22 Jun 2017 20:18:17 -0400 Subject: [PATCH] Adding IF NOT EXISTS to index creation. --- Open-ILS/src/sql/Pg/version-upgrade/2.11.1-2.11.2-upgrade-db.sql | 2 +- Open-ILS/src/sql/Pg/version-upgrade/2.11.2-2.11.3-upgrade-db.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.11.1-2.11.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.11.1-2.11.2-upgrade-db.sql index e7cadc4482..e4d2cf878c 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.11.1-2.11.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.11.1-2.11.2-upgrade-db.sql @@ -80,6 +80,6 @@ ANALYZE reporter.hold_request_record; SELECT evergreen.upgrade_deps_block_check('1005', :eg_version); -CREATE INDEX action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); +CREATE INDEX IF NOT EXISTS action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); COMMIT; diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.11.2-2.11.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.11.2-2.11.3-upgrade-db.sql index 939403150d..923d8f8085 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.11.2-2.11.3-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.11.2-2.11.3-upgrade-db.sql @@ -17,7 +17,7 @@ AND replace_spec = '901c'; SELECT evergreen.upgrade_deps_block_check('1013', :eg_version); -- csharp/miker/gmcharlt -CREATE INDEX actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname)); +CREATE INDEX IF NOT EXISTS actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname)); -- 2.11.0