From 99d5c1164f7180117760d48245db54a5a7bc0296 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 18 Sep 2017 19:10:43 -0400 Subject: [PATCH] Drop triggers on biblio.record_entry before the big update. --- .../version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) 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 0da18594c9..3a4f54fecc 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 @@ -2526,6 +2526,17 @@ DROP TRIGGER IF EXISTS a_opac_vis_mat_view_tgr ON serial.unit; DROP TRIGGER IF EXISTS a_opac_vis_mat_view_tgr ON config.copy_status; DROP TRIGGER IF EXISTS a_opac_vis_mat_view_tgr ON actor.org_unit; +-- PINES: drop additional triggers on biblio.record_entry to prevent +-- needless agony: +DROP TRIGGER IF EXISTS a_marcxml_is_well_formed ON biblio.record_entry; +DROP TRIGGER IF EXISTS aaa_indexing_ingest_or_delete ON biblio.record_entry; +DROP TRIGGER IF EXISTS audit_biblio_record_entry_update_trigger ON biblio.record_entry; +DROP TRIGGER IF EXISTS b_maintain_901 ON biblio.record_entry; +DROP TRIGGER IF EXISTS bbb_simple_rec_trigger ON biblio.record_entry; +DROP TRIGGER IF EXISTS c_maintain_control_numbers ON biblio.record_entry; +DROP TRIGGER IF EXISTS fingerprint_tgr ON biblio.record_entry; + + -- Upgrade the data! INSERT INTO asset.copy_vis_attr_cache (target_copy, record, vis_attr_vector) SELECT cp.id, @@ -2536,6 +2547,15 @@ INSERT INTO asset.copy_vis_attr_cache (target_copy, record, vis_attr_vector) UPDATE biblio.record_entry SET vis_attr_vector = biblio.calculate_bib_visibility_attribute_set(id); +-- 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(); +CREATE TRIGGER aaa_indexing_ingest_or_delete AFTER INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE biblio.indexing_ingest_or_delete(); +CREATE TRIGGER audit_biblio_record_entry_update_trigger AFTER DELETE OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE auditor.audit_biblio_record_entry_func(); +CREATE TRIGGER b_maintain_901 BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE maintain_901(); +CREATE TRIGGER bbb_simple_rec_trigger AFTER INSERT OR DELETE OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_trigger(); +CREATE TRIGGER c_maintain_control_numbers BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE public.maintain_control_numbers(); +CREATE TRIGGER fingerprint_tgr BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE biblio.fingerprint_trigger('eng', 'BKS'); + CREATE TRIGGER z_opac_vis_mat_view_tgr BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE asset.cache_copy_visibility(); CREATE TRIGGER z_opac_vis_mat_view_tgr AFTER INSERT OR DELETE ON biblio.peer_bib_copy_map FOR EACH ROW EXECUTE PROCEDURE asset.cache_copy_visibility(); CREATE TRIGGER z_opac_vis_mat_view_tgr AFTER UPDATE ON asset.call_number FOR EACH ROW EXECUTE PROCEDURE asset.cache_copy_visibility(); -- 2.11.0