From e28991688962c16e864d9795717e3bd48286d803 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 25 Feb 2019 10:30:12 -0500 Subject: [PATCH] JBAS-2192 Update bib vis attr cache for 3.2 upgrade Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-additions.sql | 33 ++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) diff --git a/KCLS/sql/schema/deploy/3.2-additions.sql b/KCLS/sql/schema/deploy/3.2-additions.sql index 1ff659874b..d0b5592b2a 100644 --- a/KCLS/sql/schema/deploy/3.2-additions.sql +++ b/KCLS/sql/schema/deploy/3.2-additions.sql @@ -145,9 +145,42 @@ CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () $$ LANGUAGE SQL; +COMMIT; + +------------------------------------------------------------------------------ +SELECT CLOCK_TIMESTAMP(), + '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) +WHERE NOT DELETED; + +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; +SELECT CLOCK_TIMESTAMP(), + 'Done updating visibility attribute vector for biblio.record_entry'; +------------------------------------------------------------------------------ + -- REBUILD reporter.materialized_simple_record after the XACT is commited. SELECT reporter.disable_materialized_simple_record_trigger(); -- 2.11.0