Ubuntu manuals

Provided by: postgresql-client-8.2_8.2.7-1_i386

NAME

       CREATE CONSTRAINT TRIGGER - define a new constraint trigger

SYNOPSIS

       CREATE CONSTRAINT TRIGGER name
           AFTER event [ OR ... ]
           ON table_name
           [ FROM referenced_table_name ]
           { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
           FOR EACH ROW
           EXECUTE PROCEDURE funcname ( arguments )

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.  The actual name of the
              created trigger will be of  the  form  RI_ConstraintTrigger_0000
              (where  0000  is  some number assigned by the server).  Use this
              assigned name when dropping the trigger.

       event  One of INSERT, UPDATE, or DELETE; this specifies the event  that
              will  fire  the  trigger. Multiple events can be specified using
              OR.

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

       referenced_table_name
              The  (possibly schema-qualified) name of the table referenced by
              the constraint. Used by foreign key constraints triggers.

       DEFERRABLE

       NOT DEFERRABLE

       INITIALLY IMMEDIATE

       INITIALLY DEFERRED
              See the CREATE TABLE [create_table(7)] documentation for details
              of these constraint options.

       funcname(args)
              The  function  to  call  as  part of the trigger processing. See
              CREATE TRIGGER [create_trigger(7)] for details.

COMPATIBILITY

       CREATE CONTRAINT TRIGGER is a PostgreSQL extension of the SQL standard.