Home → Documentation → Manuals → PostgreSQL 7.1

This page in other versions: Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0

PostgreSQL 7.1.3 Documentation
Prev		Next

CREATE CONSTRAINT TRIGGER

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.

Prev	Home	Next
CREATE AGGREGATE	Up	CREATE DATABASE

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.