aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2011-02-21 20:14:02 -0500
committerBruce Momjian <bruce@momjian.us>2011-02-21 20:14:02 -0500
commitfee7802770669398359c369aee83277dcc58edd1 (patch)
treef64b79e369ddb25e3d140eb54ff3bbb0049065c9 /doc/src
parentede45e90dd1992bfd3e1e61ce87bad494b81f54d (diff)
downloadpostgresql-fee7802770669398359c369aee83277dcc58edd1.tar.gz
postgresql-fee7802770669398359c369aee83277dcc58edd1.zip
Move information_schema duplicate constraint note to the top of the
information schema documentation because it affects several tables.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/information_schema.sgml25
1 files changed, 13 insertions, 12 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml
index 91c2dd4d525..32e90837443 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -21,6 +21,19 @@
<productname>PostgreSQL</productname>-specific views.
</para>
+ <note>
+ <para>
+ The SQL standard requires constraint names to be unique within a
+ schema; <productname>PostgreSQL</productname>, however, does not
+ enforce this restriction. If duplicate-named constraints are
+ stored in the same <productname>PostgreSQL</productname> schema,
+ a standard-compliant query that expects to return one matching
+ constraint row might return several, one row for each matching
+ constraint stored in the specified schema.
+ </para>
+ </note>
+
+
<sect1 id="infoschema-schema">
<title>The Schema</title>
@@ -3212,18 +3225,6 @@ ORDER BY c.ordinal_position;
</tgroup>
</table>
- <note>
- <para>
- The SQL standard requires constraint names to be unique within a
- schema; <productname>PostgreSQL</productname>, however, does not
- enforce this restriction. If duplicate-named constraints are
- stored in the same <productname>PostgreSQL</productname> schema, a
- standard-compliant query that expects to return one row might
- return several, one for each matching constraint stored in the
- specified schema.
- </para>
- </note>
-
</sect1>
<sect1 id="infoschema-role-column-grants">