From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 26 Mar 2018 16:08:57 +0000 (-0400)
Subject: new trigger needs to be disabled for 3.0+ systems
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=6fb82d8e89954195400ae834f2b452865671dff8

new trigger needs to be disabled for 3.0+ systems
---

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);