3 INSERT INTO config.upgrade_log (version) VALUES ('0468'); -- gmc
5 DROP TRIGGER IF EXISTS zzz_update_materialized_simple_record_tgr ON metabib.real_full_rec;
6 DROP TRIGGER IF EXISTS zzz_update_materialized_simple_rec_delete_tgr ON biblio.record_entry;
7 DROP TRIGGER IF EXISTS bbb_simple_rec_trigger ON biblio.record_entry;
9 DROP FUNCTION IF EXISTS reporter.simple_rec_sync();
10 DROP FUNCTION IF EXISTS reporter.simple_rec_bib_sync();
12 CREATE TRIGGER bbb_simple_rec_trigger
13 AFTER INSERT OR UPDATE OR DELETE ON biblio.record_entry
14 FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_trigger();
16 CREATE OR REPLACE FUNCTION reporter.disable_materialized_simple_record_trigger () RETURNS VOID AS $$
17 DROP TRIGGER IF EXISTS bbb_simple_rec_trigger ON biblio.record_entry;
20 CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$
22 DELETE FROM reporter.materialized_simple_record;
24 INSERT INTO reporter.materialized_simple_record
25 (id,fingerprint,quality,tcn_source,tcn_value,title,author,publisher,pubdate,isbn,issn)
26 SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record;
28 CREATE TRIGGER bbb_simple_rec_trigger
29 AFTER INSERT OR UPDATE OR DELETE ON biblio.record_entry
30 FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_trigger();