From 08e1433bd6601af7532cf99baf5633c1225a58e2 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sat, 20 Oct 2018 13:03:28 -0400 Subject: [PATCH] create index only if not exists --- Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql index bc276b0d57..6ca82fb70d 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql @@ -4842,7 +4842,7 @@ transits accross all transit types. */ -- Create an index for speedy check constraint lookups. -CREATE INDEX active_transit_for_copy +CREATE INDEX IF NOT EXISTS active_transit_for_copy ON action.transit_copy (target_copy) WHERE dest_recv_time IS NULL AND cancel_time IS NULL; -- 2.11.0