From 6fb82d8e89954195400ae834f2b452865671dff8 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 26 Mar 2018 12:08:57 -0400 Subject: [PATCH] new trigger needs to be disabled for 3.0+ systems --- remove_ou_data/08_remove_volumes.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/remove_ou_data/08_remove_volumes.sql b/remove_ou_data/08_remove_volumes.sql index 71fc03a..819ac75 100644 --- a/remove_ou_data/08_remove_volumes.sql +++ b/remove_ou_data/08_remove_volumes.sql @@ -24,6 +24,7 @@ DROP TABLE IF EXISTS esi.:vol_del_table; ALTER TABLE asset.call_number DISABLE RULE protect_cn_delete; ALTER TABLE asset.call_number DISABLE TRIGGER audit_asset_call_number_update_trigger; +ALTER TABLE asset.call_number DISABLE TRIGGER z_opac_vis_mat_view_tgr; BEGIN; @@ -49,5 +50,6 @@ COMMIT; ALTER TABLE asset.call_number ENABLE RULE protect_cn_delete; ALTER TABLE asset.call_number ENABLE TRIGGER audit_asset_call_number_update_trigger; +ALTER TABLE asset.call_number ENABLE TRIGGER z_opac_vis_mat_view_tgr; CREATE INDEX org_vol_bib_idx ON esi.:vol_del_table(record); -- 1.7.2.5