From 826d5ba27d47123982a9fc06b44847cca125c24e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 18 Sep 2017 20:50:53 -0400 Subject: [PATCH] Exclude deleted records from huge update. --- Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql index 3a4f54fecc..189cab3626 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql @@ -2545,7 +2545,8 @@ INSERT INTO asset.copy_vis_attr_cache (target_copy, record, vis_attr_vector) FROM asset.copy cp JOIN asset.call_number cn ON (cp.call_number = cn.id); -UPDATE biblio.record_entry SET vis_attr_vector = biblio.calculate_bib_visibility_attribute_set(id); +-- PINES: exclude deleted recs +UPDATE biblio.record_entry SET vis_attr_vector = biblio.calculate_bib_visibility_attribute_set(id) WHERE NOT DELETED; -- PINES: restore dropped triggers: CREATE TRIGGER a_marcxml_is_well_formed BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE biblio.check_marcxml_well_formed(); -- 2.11.0