September 25, 2025: PostgreSQL 18 Released!

Unsupported versions: 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

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.

PostgreSQL 7.4.30 Documentation
Prev	Fast Backward	Fast Forward	Next

CREATE CONSTRAINT TRIGGER

Name

CREATE CONSTRAINT TRIGGER -- define a new constraint trigger

Synopsis

CREATE CONSTRAINT TRIGGER name
 AFTER events ON
 tablename constraint attributes
 FOR EACH ROW EXECUTE PROCEDURE funcname ( args )

Description

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.

Parameters

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.

Prev	Home	Next
CREATE CAST	Up	CREATE CONVERSION