Open-ILS/src/sql/Pg/upgrade/0462.schema.no-truncate-during-bib-view-refresh.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0462'); -- gmc
   4
   5 CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$
   6
   7     DELETE FROM reporter.materialized_simple_record;
   8
   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;
  12
  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();
  16
  17 $$ LANGUAGE SQL;
  18
  19 COMMIT;