Skip site navigation (1) Skip section navigation (2)

Re: bug in information_schema?

From: Troels Arvin <troels(at)arvin(dot)dk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug in information_schema?
Date: 2004-11-27 15:19:31
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Sat, 27 Nov 2004 14:24:40 +0000, Andrew - Supernews wrote:

> A similar issue may exist with the check_constraints view, which was the
> only other place I found where constraint_name is used without any table
> name being present. I don't know what the spec says, but it seems that
> something is assuming that constraint_name is unique within the schema,
> which of course is not the case in the above example.

It has been discussed elsewhere some months ago:

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 :-(

Greetings from Troels Arvin, Copenhagen, Denmark

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2004-11-27 17:43:53
Subject: Re: plpgsql unreachable code (was BUG #1329: Bug in IF-ELSEIF-ELSE construct)
Previous:From: Andrew - SupernewsDate: 2004-11-27 14:24:40
Subject: bug in information_schema?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group