Re: pg_attribute.attnum - wrong column ordinal? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_attribute.attnum - wrong column ordinal?
Date
Msg-id 8576.1259852957@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_attribute.attnum - wrong column ordinal?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: pg_attribute.attnum - wrong column ordinal?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Should we recast the attributes and columns views in information_schema?
> I notice they still use attnum.

I'd vote against it, at least until we have something better than a
row_number solution.  That would create another huge performance penalty
on views that are already ungodly slow.

When and if we get around to separating physical from logical column
position, the issue might go away "for free".

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric cast oddity
Next
From: Adrian Klaver
Date:
Subject: Re: Catastrophic changes to PostgreSQL 8.4