From d3c57a52c97fde378c0766127e72479a93bf83bd Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 27 Sep 2017 14:34:07 -0400 Subject: [PATCH] LP#1719726: Make sure all relevant triggers are disabled for bib visibility update Signed-off-by: Mike Rylander Signed-off-by: Galen Charlton --- .../src/sql/Pg/version-upgrade/2.12.5-3.0-beta1-upgrade-db.sql | 2 ++ 1 file changed, 2 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 ae619d987d..f5454e48fe 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 @@ -7092,6 +7092,7 @@ 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) WHERE NOT DELETED; @@ -7102,6 +7103,7 @@ 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