From 11ab00b1890c3d61b22d100424d41ae0060a35f3 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 26 Aug 2014 15:39:00 -0400 Subject: [PATCH] LP#778989: Adding DROP TRIGGER IF EXISTS to allow for smooth upgrades. Signed-off-by: Chris Sharp Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql index c0a8fc5fb4..f2d4011a37 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql @@ -19,6 +19,8 @@ BEGIN END; $$ LANGUAGE plpgsql; +DROP TRIGGER IF EXISTS acp_location_fixer_trig ON asset.copy; + CREATE TRIGGER acp_location_fixer_trig BEFORE INSERT OR UPDATE OF location, call_number, circ_lib ON asset.copy FOR EACH ROW EXECUTE PROCEDURE asset.acp_location_fixer(); -- 2.11.0