From 45e18580716813d5f5e323f7122a53f60a541e6a Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 23 Mar 2018 16:35:16 -0400 Subject: [PATCH] LP#1758426: Disable triggers before recalculating bib visibility Disabling triggers in the 3.0.2-3.0.3 upgrade script to speed up the recalculation of bib visibility. These are the same triggers that were disabled when performing a similar recalculation in the 2.12.6-3.0.0 upgrade script. Signed-off-by: Kathy Lussier Signed-off-by: Ben Shum --- .../3.0.2-3.0.3-upgrade-db.sql | 23 +++++++++++++++++++ 1 file changed, 23 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.0.2-3.0.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.0.2-3.0.3-upgrade-db.sql index 74a7c01170..6ca665dad3 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.0.2-3.0.3-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.0.2-3.0.3-upgrade-db.sql @@ -273,6 +273,18 @@ $f$ LANGUAGE PLPGSQL STABLE ROWS 1; COMMIT; +\echo --------------------------------------------------------------------- +\echo Updating visibility attribute vector for biblio.record_entry +BEGIN; + +ALTER TABLE biblio.record_entry DISABLE TRIGGER a_marcxml_is_well_formed; +ALTER TABLE biblio.record_entry DISABLE TRIGGER aaa_indexing_ingest_or_delete; +ALTER TABLE biblio.record_entry DISABLE TRIGGER audit_biblio_record_entry_update_trigger; +ALTER TABLE biblio.record_entry DISABLE TRIGGER b_maintain_901; +ALTER TABLE biblio.record_entry DISABLE TRIGGER bbb_simple_rec_trigger; +ALTER TABLE biblio.record_entry DISABLE TRIGGER c_maintain_control_numbers; +ALTER TABLE biblio.record_entry DISABLE TRIGGER fingerprint_tgr; +ALTER TABLE biblio.record_entry DISABLE TRIGGER z_opac_vis_mat_view_tgr; UPDATE biblio.record_entry SET vis_attr_vector = biblio.calculate_bib_visibility_attribute_set(id) @@ -289,3 +301,14 @@ UPDATE biblio.record_entry UNION SELECT id FROM biblio.record_entry WHERE source IS NOT NULL ); + +ALTER TABLE biblio.record_entry ENABLE TRIGGER a_marcxml_is_well_formed; +ALTER TABLE biblio.record_entry ENABLE TRIGGER aaa_indexing_ingest_or_delete; +ALTER TABLE biblio.record_entry ENABLE TRIGGER audit_biblio_record_entry_update_trigger; +ALTER TABLE biblio.record_entry ENABLE TRIGGER b_maintain_901; +ALTER TABLE biblio.record_entry ENABLE TRIGGER bbb_simple_rec_trigger; +ALTER TABLE biblio.record_entry ENABLE TRIGGER c_maintain_control_numbers; +ALTER TABLE biblio.record_entry ENABLE TRIGGER fingerprint_tgr; +ALTER TABLE biblio.record_entry ENABLE TRIGGER z_opac_vis_mat_view_tgr; + +COMMIT; -- 2.43.2