diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-10-08 21:44:17 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-10-17 15:10:33 -0400 |
| commit | c29c578908dc0271eeb13a4014e54bff07a29c05 (patch) | |
| tree | 1aa03fb6f1864719f2f23d4b0b9d5e2865764082 /doc/src/sgml/ref/set_constraints.sgml | |
| parent | 6ecabead4b5993c42745f2802d857b1a79f48bf9 (diff) | |
| download | postgresql-c29c578908dc0271eeb13a4014e54bff07a29c05.tar.gz postgresql-c29c578908dc0271eeb13a4014e54bff07a29c05.zip | |
Don't use SGML empty tags
For DocBook XML compatibility, don't use SGML empty tags (</>) anymore,
replace by the full tag name. Add a warning option to catch future
occurrences.
Alexander Lakhin, Jürgen Purtz
Diffstat (limited to 'doc/src/sgml/ref/set_constraints.sgml')
| -rw-r--r-- | doc/src/sgml/ref/set_constraints.sgml | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 7c31871b0bd..237a0a3988f 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -67,18 +67,18 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">name</replaceable> [, ... </para> <para> - Currently, only <literal>UNIQUE</>, <literal>PRIMARY KEY</>, - <literal>REFERENCES</> (foreign key), and <literal>EXCLUDE</> + Currently, only <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, + <literal>REFERENCES</literal> (foreign key), and <literal>EXCLUDE</literal> constraints are affected by this setting. - <literal>NOT NULL</> and <literal>CHECK</> constraints are + <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints are always checked immediately when a row is inserted or modified - (<emphasis>not</> at the end of the statement). + (<emphasis>not</emphasis> at the end of the statement). Uniqueness and exclusion constraints that have not been declared - <literal>DEFERRABLE</> are also checked immediately. + <literal>DEFERRABLE</literal> are also checked immediately. </para> <para> - The firing of triggers that are declared as <quote>constraint triggers</> + The firing of triggers that are declared as <quote>constraint triggers</quote> is also controlled by this setting — they fire at the same time that the associated constraint should be checked. </para> @@ -111,7 +111,7 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">name</replaceable> [, ... This command complies with the behavior defined in the SQL standard, except for the limitation that, in <productname>PostgreSQL</productname>, it does not apply to - <literal>NOT NULL</> and <literal>CHECK</> constraints. + <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints. Also, <productname>PostgreSQL</productname> checks non-deferrable uniqueness constraints immediately, not at end of statement as the standard would suggest. |