PostgreSQL 7.3.4 Documentation
Prev |  | Next

# CREATE CONSTRAINT TRIGGER

## Name

CREATE CONSTRAINT TRIGGER -- define a new constraint trigger

## 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

  The name (possibly schema-qualified) of the relation in which the triggering events occur.

constraint

  Actual constraint specification.

attributes

  Constraint attributes.

func(args)

  Function to call as part of the trigger processing.

### Outputs

`CREATE TRIGGER`

  Message returned if successful.

## Description

`CREATE CONSTRAINT TRIGGER` is used within `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 CAST | Up | CREATE CONVERSION