This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
CREATE CONSTRAINT TRIGGER
Name
CREATE CONSTRAINT TRIGGER -- define a
new constraint trigger
Synopsis
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.