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 200312151553.42148.peter_e@gmx.net
Whole thread Raw
In response to Re: BUG #1006: information schema constraint information.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #1006: information schema constraint information.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> If the view were also supposed to show referenced columns, then I
> think we'd need an additional UNION arm that joined on confrelid and
> confkey[] instead of conrelid/conkey[].  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.

Both the current behavior and his proposed correction are incorrect.
Will investigate later.

pgsql-bugs by date:

Previous
From: Joe Conway
Date:
Subject: Re: BUG #1007: error during installation
Next
From: Tom Lane
Date:
Subject: Re: BUG #1006: information schema constraint information.