From: Bruce Momjian <bruce@momjian.us>
To: bruce@momjian.us
Cc: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS
Date: Tue, 22 Feb 2011 09:07:39 -0500 (EST)
Message-ID: <201102221407.p1ME7dA17560@momjian.us> (raw)
bruce wrote:
>
> I have moved the text about duplicate constraints to the top of the
> information schema section because it affects several tables (applied
> patch attached). I could not figure out how to get the actual error
> concept to the front of the paragraph.
I found a way to reword the paragraph to be clearer about its purpose:
When querying the database for constraint information, it is possible
for a standard-compliant query that expects to return one row to
return several. This is because the SQL standard requires constraint
names to be unique within a schema, but
<productname>PostgreSQL</productname> does not enforce this
restriction. <productname>PostgreSQL</productname>
automatically-generated constraint names avoid duplicates in the
same schema, but users can specify such duplicate names.
Applied.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, coelho@cri.ensmp.fr, peter_e@gmx.net, tgl@sss.pgh.pa.us, alvherre@commandprompt.com
Subject: Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS
In-Reply-To: <201102221407.p1ME7dA17560@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox