create_constraint_trigger7l

Define a new constraint trigger

Usage

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 constraint specification.

attributes: Constraint attributes.

func(args): Function to call as part of the trigger processing.

Outputs

CREATE CONSTRAINT: Message returned if successful.

Overview

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.