Rechercher une page de manuel
create_constraint_trigger
Langue: en
Version: 2007-04-20 (fedora - 16/08/07)
Section: 7 (Divers)
NAME
CREATE CONSTRAINT TRIGGER - define a new constraint triggerSYNOPSIS
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.
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre