From 18d497bf5072a4d8bf5b15a062498439f4aef028 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Sun, 4 Sep 2016 14:14:20 -0400 Subject: [PATCH] Drop the hold_request_clear_map_tgr trigger before creating 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..ba4b48e28c 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 IF EXISTS 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