X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2F08_remove_volumes.sql;fp=remove_ou_data%2F08_remove_volumes.sql;h=819ac7530bfc270966e12dac1bfc98333adbf553;hp=71fc03a4c816f689f23228b47b4816d9d2f6b85b;hb=6fb82d8e89954195400ae834f2b452865671dff8;hpb=aba77657ccc6e619b78587b4966d40341999f12a

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