From 72d8a868b7d8282fc081800422b4848cd4a9fa20 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 17 Oct 2016 14:50:31 -0400 Subject: [PATCH] removed moving call numbers where items and call numbers were on incompatible orgs to be deleted --- remove_ou_data/07_remove_volumes.sql | 9 --------- 1 files changed, 0 insertions(+), 9 deletions(-) diff --git a/remove_ou_data/07_remove_volumes.sql b/remove_ou_data/07_remove_volumes.sql index edea650..5eaec2e 100644 --- a/remove_ou_data/07_remove_volumes.sql +++ b/remove_ou_data/07_remove_volumes.sql @@ -39,15 +39,6 @@ FROM asset.call_number WHERE owning_lib IN DELETE FROM asset.call_number WHERE owning_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); -UPDATE asset.call_number acn SET owning_lib = ac.circ_lib -FROM asset.copy ac -WHERE ac.call_number = acn.id -AND acn.owning_lib IN -(SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del) -AND acn.id IN -(SELECT call_number FROM asset.copy WHERE circ_lib NOT IN - (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del)); - COMMIT; ALTER TABLE asset.call_number ENABLE RULE protect_cn_delete; -- 1.7.2.5