From 62ee2baa46bfe885bad09fbc5e3a4a2520ff0e16 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Sun, 31 Jul 2016 14:09:01 -0400 Subject: [PATCH] We need to drop the trigger before we add it Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.8.0-upgrade-db.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.8.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.8.0-upgrade-db.sql index a8a04aab35..57f35302d2 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.8.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.8.0-upgrade-db.sql @@ -12,6 +12,7 @@ BEGIN END; $$ LANGUAGE PLPGSQL; +DROP TRIGGER hold_request_clear_map_tgr ON action.hold_request; CREATE TRIGGER hold_request_clear_map_tgr AFTER UPDATE ON action.hold_request FOR EACH ROW -- 2.11.0