diff options
Diffstat (limited to 'doc/src/sgml/ref/set_constraints.sgml')
-rw-r--r-- | doc/src/sgml/ref/set_constraints.sgml | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml deleted file mode 100644 index ed15b09a24c..00000000000 --- a/doc/src/sgml/ref/set_constraints.sgml +++ /dev/null @@ -1,76 +0,0 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_constraints.sgml,v 1.4 2002/06/03 01:10:38 momjian Exp $ --> -<refentry id="SQL-SET-CONSTRAINTS"> - <refmeta> - <refentrytitle id="SQL-SET-CONSTRAINTS-title">SET CONSTRAINTS</refentrytitle> - <refmiscinfo>SQL - Language Statements</refmiscinfo> - </refmeta> - <refnamediv> - <refname>SET CONSTRAINTS</refname> - <refpurpose>set the constraint mode of the current transaction</refpurpose> - </refnamediv> - <refsynopsisdiv> - <refsynopsisdivinfo> - <date>2000-06-01</date> - </refsynopsisdivinfo> - <synopsis> -SET CONSTRAINTS { ALL | <replaceable class="parameter">constraint</replaceable> [, ...] } { DEFERRED | IMMEDIATE } - </synopsis> - </refsynopsisdiv> - - <refsect1> - <title>Description</title> - - <para> - <command>SET CONSTRAINTS</command> sets the behavior of constraint - evaluation in the current transaction. In - <option>IMMEDIATE</option> mode, constraints are checked at the end - of each statement. In <option>DEFERRED</option> mode, constraints - are not checked until transaction commit. - </para> - - <para> - Upon creation, a constraint is always give one of three - characteristics: <option>INITIALLY DEFERRED</option>, - <option>INITIALLY IMMEDIATE DEFERRABLE</option>, or - <option>INITIALLY IMMEDIATE NOT DEFERRABLE</option>. The third - class is not affected by the <command>SET CONSTRAINTS</command> - command. - </para> - - <para> - Currently, only foreign key constraints are affected by this - setting. Check and unique constraints are always effectively - initially immediate not deferrable. - </para> - </refsect1> - - <refsect1 id="R1-SQL-SET-CONSTRAINT-3"> - <title>Compatibility</title> - - <refsect2 id="R2-SQL-SET-CONSTRAINT-4"> - <title>SQL92, SQL99</title> - - <para> - <command>SET CONSTRAINTS</command> is defined in - <acronym>SQL92</acronym> and <acronym>SQL99</acronym>. - </para> - </refsect2> - </refsect1> -</refentry> - -<!-- Keep this comment at the end of the file -Local variables: -mode:sgml -sgml-omittag:nil -sgml-shorttag:t -sgml-minimize-attributes:nil -sgml-always-quote-attributes:t -sgml-indent-step:1 -sgml-indent-data:t -sgml-parent-document:nil -sgml-default-dtd-file:"../reference.ced" -sgml-exposed-tags:nil -sgml-local-catalogs:("/usr/lib/sgml/catalog") -sgml-local-ecat-files:nil -End: ---> |