CREATE CONSTRAINT TRIGGER — define a new constraint trigger
CREATE CONSTRAINT TRIGGERname
AFTERevents
ONtablename
constraint
attributes
FOR EACH ROW EXECUTE PROCEDUREfuncname
(args
)
CREATE CONSTRAINT TRIGGER
is used within
CREATE TABLE
/ALTER TABLE
and by
pg_dump to create the special triggers for
referential integrity.
It is not intended for general use.
name
The name of the constraint trigger.
events
The event categories for which this trigger should be fired.
tablename
The name (possibly schema-qualified) of the table in which the triggering events occur.
constraint
Actual constraint specification.
attributes
The constraint attributes.
funcname
(args
)The function to call as part of the trigger processing.