Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> 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... ] Ye
Peter Eisentraut <[EMAIL PROTECTED]> 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 ar
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.
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> [ information_schema.constraint_column_usage gives wrong answers ]
I think this part of the view's definition:
AND (CASE WHEN c.contype = 'f' THEN c.confkey[pos.n] = a.attnum
ELSE c.conkey[pos.n] = a.attnum END
