CREATE CONSTRAINT TRIGGER
SQL - Language Statements
CREATE CONSTRAINT TRIGGER
define a new constraint trigger
2000-04-13
CREATE CONSTRAINT TRIGGER name
AFTER events ON
relation constraint attributes
FOR EACH ROW EXECUTE PROCEDURE func '(' args ')'
Inputs
name
The name of the constraint trigger.
events
The event categories for which this trigger should be fired.
relation
The name (possibly schema-qualified) of the relation in which
the triggering events occur.
constraint
Actual constraint specification.
attributes
Constraint attributes.
func(args)
Function to call as part of the trigger processing.
Outputs
CREATE TRIGGER
Message returned if successful.
Description
CREATE CONSTRAINT TRIGGER is used within
CREATE/ALTER TABLE and by
pg_dump to create the special triggers for
referential integrity.
It is not intended for general use.