diff options
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 19 |
1 files changed, 9 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 0628ed673a6..172151eddd3 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.40 2000/04/14 15:17:28 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.41 2000/04/14 23:12:29 momjian Exp $ Postgres documentation --> @@ -269,10 +269,9 @@ SELECT setseed(<replaceable>value</replaceable>); <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> @@ -296,11 +295,11 @@ SELECT setseed(<replaceable>value</replaceable>); </para> <para> - In deferred mode, the actual check of the constraint is held - back until either its mode is explicitly set to <option>IMMEDIATE</option>, - or until COMMIT. This is actually only done for foreign key - constraints, so it does not apply to UNIQUE or other - constraints. + In <option>DEFERRED</option> mode, foreign key constraints + marked as <option>DEFERRABLE</option> are checked only at + transaction commit. + In <option>IMMEDIATE</option> mode, foreign key constraints + are checked at the end of each query. </para> </listitem> </varlistentry> |