From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 27 Feb 2017 13:35:55 +0000 (-0500)
Subject: add disable/renable rule so that copy locations can be deleted in remove_ou scripts
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=06e695c596e784a9e2634b25612b4bd23ac047af;hp=39c739cec27e2fc042d2f0ab72930a41604a3d45

add disable/renable rule so that copy locations can be deleted in remove_ou scripts
---

diff --git a/remove_ou_data/14_remove_ou_extras.sql b/remove_ou_data/14_remove_ou_extras.sql
index 781090a..08bab80 100644
--- a/remove_ou_data/14_remove_ou_extras.sql
+++ b/remove_ou_data/14_remove_ou_extras.sql
@@ -21,6 +21,7 @@
 
 create index tmp_idx on money.billing(btype);
 ALTER TABLE action.circulation DISABLE TRIGGER action_circulation_target_copy_trig;
+ALTER TABLE asset.copy_location DISABLE RULE protect_copy_location_delete;
 
 BEGIN;
 
@@ -68,4 +69,5 @@ DELETE FROM action_trigger.event_definition
 
 COMMIT;
 DROP INDEX money.tmp_idx;
+ALTER TABLE asset.copy_location ENABLE RULE protect_copy_location_delete;
 ALTER TABLE action.circulation ENABLE TRIGGER action_circulation_target_copy_trig;