Troels Arvin <troels@arvin.dk> writes:
> On Sat, 27 Nov 2004 14:24:40 +0000, Andrew - Supernews wrote:
>> something is assuming that constraint_name is unique within the schema,
>> which of course is not the case in the above example.
> The problem makes the INFORMATION_SCHEMA rather useless for some kinds of
> queries, like you have shown. However, I don't believe that schema-unique
> constraint names will be an option any time soon, due to backwards
> compatibility :-(
We have changed 8.0 to ensure that automatically-generated constraint
names are unique across a schema. I doubt we will ever enforce that
against user-specified names, though. If you want to use the
information schema to trace constraints, you'll have to impose that
discipline on yourself.
regards, tom lane