<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.40 2000/04/1415:17:28 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.41 2000/04/1423:12:29 momjian Exp $

Postgres documentation

-->

<term>CONSTRAINT</term>

<listitem>

<para>

SET CONSTRAINTS is the SQL3 specified command to change the

default behaviour of constraints with respect to deferring in the current

transaction. Allowed parameters are:

SET CONSTRAINTS controls the frequency of foreign key

constratint checking in the current transaction. Allowed

parameters are:

<variablelist>

<varlistentry>

<term><replaceable class="parameter">constraintlist</replaceable></term>

</para>

<para>

Indeferred mode,the actual check of the constraint is held

back until either its mode is explicitly set to<option>IMMEDIATE</option>,

constraints.

In<option>DEFERRED</option> mode,foreign key constraints

marked as<option>DEFERRABLE</option> are checked only at

are checked at the end of each query.

</para>

</listitem>

</varlistentry>