CREATE CONSTRAINT TRIGGER

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.

Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
If only Dionysus were alive! Where would he eat? -- Woody Allen
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!