CREATE CONSTRAINT TRIGGER -- define a new constraint trigger
Synopsis
CREATE CONSTRAINT TRIGGER name AFTER events ON tablenameconstraintattributes 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.
Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
Free Sample Chapters