egdb3_11_7
.acq
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
create_acq_update_trigger(sch text, tbl text)
Parameters
Name
Type
Mode
sch
text
IN
tbl
text
IN
Definition
BEGIN EXECUTE $$ CREATE TRIGGER audit_$$ || sch || $$_$$ || tbl || $$_update_trigger AFTER UPDATE OR DELETE ON $$ || sch || $$.$$ || tbl || $$ FOR EACH ROW EXECUTE PROCEDURE acq.audit_$$ || sch || $$_$$ || tbl || $$_func (); $$; RETURN TRUE; END;