aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/information_schema.sgml10
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml
index 21e4f98913a..aa6f852a8a3 100644
--- a/doc/src/sgml/information_schema.sgml
+++ b/doc/src/sgml/information_schema.sgml
@@ -32,6 +32,16 @@
automatically-generated constraint names avoid duplicates in the
same schema, but users can specify such duplicate names.
</para>
+
+ <para>
+ This problem can appear when querying information schema views like
+ <literal>referential_constraints</>, <literal>check_constraints</>,
+ <literal>domain_constraints</>, and
+ <literal>check_constraint_routine_usage</>. Some other views have
+ similar issues but contain the table name to help distinguish
+ duplicate rows, e.g. <literal>table_constraints</>,
+ <literal>constraint_table_usage</>, <literal>constraint_column_usage</>.
+ </para>
</note>