3 INSERT INTO config.upgrade_log (version) VALUES ('0462'); -- gmc
5 CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$
7 DELETE FROM reporter.materialized_simple_record;
9 INSERT INTO reporter.materialized_simple_record
10 (id,fingerprint,quality,tcn_source,tcn_value,title,author,publisher,pubdate,isbn,issn)
11 SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record;
13 CREATE TRIGGER zzz_update_materialized_simple_record_tgr
14 AFTER INSERT OR UPDATE OR DELETE ON metabib.real_full_rec
15 FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_sync();