PostgreSQL 7.4 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