Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1006: information schema constraint information. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1006: information schema constraint information.
Date
Msg-id 12687.1071501083@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1006: information schema constraint information.  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: BUG #1006: information schema constraint information.  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> But if I read SQL99 correctly, only referencing not referenced
>> columns are supposed to be shown.

> It is supposed to show the referenced (primary key) columns.

[ reads spec more carefully... ]  Yeah, I think you are right.
We are going to need a separate UNION arm for the foreign-key case.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #1006: information schema constraint information.
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1008: fe-misc.c has an ifdef for HAVE_POLL, should be HAVE_POLL_H