From 27758f7ca62d0dc9f525c20f8380bb3f356b7062 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 31 Oct 2019 13:53:06 -0400 Subject: [PATCH] disable trigger USER, not ALL --- Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql index cba1a91d82..7be77785d1 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql @@ -811,8 +811,8 @@ END; $$ LANGUAGE 'plpgsql'; -- Disable triggers on action circulation & aged circulation for the updates that follow -ALTER TABLE action.circulation DISABLE TRIGGER ALL; -ALTER TABLE action.aged_circulation DISABLE TRIGGER ALL; +ALTER TABLE action.circulation DISABLE TRIGGER USER; +ALTER TABLE action.aged_circulation DISABLE TRIGGER USER; SELECT evergreen.upgrade_deps_block_check('1188', :eg_version); @@ -868,8 +868,8 @@ INSERT INTO permission.perm_list ( id, code, description ) SELECT DISTINCT WHERE NOT EXISTS (SELECT 1 FROM permission.perm_list WHERE code = 'EDIT_SELF_IN_CLIENT'); -- Re-enable triggers on action circulation & aged circulation -ALTER TABLE action.circulation ENABLE TRIGGER ALL; -ALTER TABLE action.aged_circulation ENABLE TRIGGER ALL; +ALTER TABLE action.circulation ENABLE TRIGGER USER; +ALTER TABLE action.aged_circulation ENABLE TRIGGER USER; -- 2.11.0