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

From Peter Eisentraut
Subject Re: BUG #1006: information schema constraint information.
Date
Msg-id 200312161559.29990.peter_e@gmx.net
Whole thread Raw
In response to Re: BUG #1006: information schema constraint information.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> 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.

Fixed.  The union branch was already trying to differentiate between
primary key and foreign key when joining the columns, but not when
joining the tables.  Just a thinko.

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: pg_service.conf ignores dbname parameter
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1009: ERROR: could not open segment 1 of relation...