egdb3_14_1
.reporter
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
enable_materialized_simple_record_trigger()
Parameters
Name
Type
Mode
IN
Definition
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();