create_constraint_trigger man page on OpenServer

Man page or keyword search:  
man Server   5388 pages
apropos Keyword Search (all sections)
Output format
OpenServer logo
[printable version]

CREATE CONSTRAINT TRIGGER()	 SQL Commands	   CREATE CONSTRAINT TRIGGER()

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 cre‐
	      ated 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(5)] documentation for details
	      of these constraint options.

       funcname(args)
	      The function to call as part of the trigger processing. See CRE‐
	      ATE TRIGGER [create_trigger(5)] for details.

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

SQL - Language Statements	  2008-06-08	   CREATE CONSTRAINT TRIGGER()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server OpenServer

List of man pages available for OpenServer

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net