create_constraint_trigger(7)

create_constraint_trigger7

Define a new constraint trigger

Usage

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

Overview

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.

From postgresql 7.4.7-6sarge6 in Debian 3.1 (Sarge). Parsed by carta from the page's man source.