From 98cd3aaf799ed11151cae37787a2888bb501bea7 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 16 Oct 2010 15:35:39 +0000 Subject: [PATCH] need to update this index as well git-svn-id: svn://svn.open-ils.org/ILS/trunk@18365 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index 3a6b9523b..0edf98b0c 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -1,6 +1,10 @@ -- Before starting the transaction: drop some constraints that -- may or may not exist. +DROP INDEX asset.asset_call_number_upper_label_id_owning_lib_idx; +CREATE INDEX asset_call_number_upper_label_id_owning_lib_idx ON asset.call_number (oils_text_as_bytea(upper(label)),id,owning_lib); + + \qecho Before starting the transaction: drop some constraints. \qecho If a DROP fails because the constraint doesn't exist, ignore the failure. -- 2.11.0