From d8f574e35f03e026c6ba60e04f679092f363ad78 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 1 Feb 2019 12:37:29 -0500 Subject: [PATCH] JBAS-2182 Rebuild reporter simple record for 3.2 upgrade Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-additions.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) diff --git a/KCLS/sql/schema/deploy/3.2-additions.sql b/KCLS/sql/schema/deploy/3.2-additions.sql index a5da53061b..3c355af612 100644 --- a/KCLS/sql/schema/deploy/3.2-additions.sql +++ b/KCLS/sql/schema/deploy/3.2-additions.sql @@ -38,5 +38,28 @@ BEGIN END IF; -- insert_on_deploy END $INSERT$; +-- BACK-PORTING https://bugs.launchpad.net/evergreen/+bug/1811689 +-- which is not yet merged to master, but needed for 3.2 upgrade. +CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$ + + TRUNCATE TABLE reporter.materialized_simple_record; + + INSERT INTO reporter.materialized_simple_record + (id,fingerprint,quality,tcn_source,tcn_value,title,author,publisher,pubdate,isbn,issn) + SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record; + + CREATE TRIGGER bbb_simple_rec_trigger + AFTER INSERT OR UPDATE OR DELETE ON biblio.record_entry + FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_trigger(); + +$$ LANGUAGE SQL; + COMMIT; +-- REBUILD reporter.materialized_simple_record after the XACT is commited. +SELECT reporter.disable_materialized_simple_record_trigger(); + +SELECT CLOCK_TIMESTAMP(), 'Rebuilding reporter.materialized_simple_record...'; +SELECT reporter.enable_materialized_simple_record_trigger(); +SELECT CLOCK_TIMESTAMP(), 'Done rebuilding reporter.materialized_simple_record...'; + -- 2.11.0