Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for set_constraints (redhat section 7)

SET CONSTRAINTS(7)			   SQL Commands 		       SET CONSTRAINTS(7)

NAME
       SET CONSTRAINTS - set the constraint mode of the current transaction

SYNOPSIS
       SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }

DESCRIPTION
       SET  CONSTRAINTS sets the behavior of constraint evaluation in the current transaction. In
       IMMEDIATE mode, constraints are checked at the end of each statement.  In  DEFERRED  mode,
       constraints are not checked until transaction commit.

	      Note:  This  command  only  alters  the  behavior of constraints within the current
	      transaction. Thus, if you execute this command outside of an  explicit  transaction
	      block  (such as one started with BEGIN), it will not appear to have any effect.  If
	      you wish to change the behavior of a constraint without needing to issue a SET CON-
	      STRAINTS	command  in  every  transaction,  specify INITIALLY DEFERRED or INITIALLY
	      IMMEDIATE when you create the constraint.

       When you change the mode of a constraint to be IMMEDIATE , the new constraint  mode  takes
       effect  retroactively:  any outstanding data modifications that would have been checked at
       the end of the transaction (when using DEFERRED) are instead checked during the	execution
       of the SET CONSTRAINTS command.

       Upon  creation,	a  constraint  is  always  give  one  of three characteristics: INITIALLY
       DEFERRED, INITIALLY IMMEDIATE DEFERRABLE, or INITIALLY IMMEDIATE NOT DEFERRABLE. The third
       class is not affected by the SET CONSTRAINTS command.

       Currently,  only  foreign  key  constraints are affected by this setting. Check and unique
       constraints are always effectively initially immediate not deferrable.

COMPATIBILITY
   SQL92, SQL99
       SET CONSTRAINTS is defined in SQL92 and SQL99. The implementation in  PostgreSQL  complies
       with  the  behavior defined in the standard, except for the PostgreSQL limitation that SET
       CONSTRAINTS cannot be applied to check or unique constraints.

SQL - Language Statements		    2002-11-22			       SET CONSTRAINTS(7)


All times are GMT -4. The time now is 04:04 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password