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.
Name
CREATE CONSTRAINT TRIGGER -- Create a
trigger to support a constraint
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
-
Table name of the triggering relation.
- constraint
-
Actual onstraint specification.
- attributes
-
Constraint attributes.
- func(args)
-
Function to call as part of the trigger
processing.
Outputs
- CREATE CONSTRAINT
-
Message returned if successful.
Description
CREATE CONSTRAINT TRIGGER is used from
inside of CREATE/ALTER TABLE and by
pg_dump to create the special
triggers for referential integrity.
It is not intended for general use.