Open-ILS/src/sql/Pg/upgrade/1155.schema.reporter-simple-rec-truncate.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('1155', :eg_version);
   4
   5 CREATE OR REPLACE FUNCTION reporter.enable_materialized_simple_record_trigger () RETURNS VOID AS $$
   6
   7     TRUNCATE TABLE 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 bbb_simple_rec_trigger
  14         AFTER INSERT OR UPDATE OR DELETE ON biblio.record_entry
  15         FOR EACH ROW EXECUTE PROCEDURE reporter.simple_rec_trigger();
  16
  17 $$ LANGUAGE SQL;
  18
  19
  20 COMMIT;