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
The following bug has been logged online:
Bug reference: 1006
Logged by: Majolee InfoTech
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Redhat 9.0
Description:information schema constraint information.
Details:
Hello,
as per the documen
