From 2239928bb7d1e02c281f6311d5d6358cbaeb4278 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 22 Oct 2014 14:33:34 -0400 Subject: [PATCH] Try dropping this trigger first before creating it and erroring out! --- Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql index 4b926e4215..78c8c63663 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql @@ -4045,6 +4045,8 @@ BEGIN END; $f$ LANGUAGE PLPGSQL; +DROP TRIGGER IF EXISTS hold_copy_proximity_update_tgr ON action.hold_copy_map; + CREATE TRIGGER hold_copy_proximity_update_tgr BEFORE INSERT OR UPDATE ON action.hold_copy_map FOR EACH ROW EXECUTE PROCEDURE action.hold_copy_calculated_proximity_update (); -- Now, cause the update we need in a HOT-friendly manner (http://pgsql.tapoueh.org/site/html/misc/hot.html) -- 2.11.0