Re: Column storage positions - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: Column storage positions
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901CAF72A@m0143.s-mxs.net
Whole thread Raw
In response to Re: Column storage positions  (Kris Jurka <books@ejurka.com>)
Responses Re: Column storage positions  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
> > And I also see a lot of unhappiness from users of system tables when

> > column numbers all over the system tables would not be logical
column
> > positions any more.
>
> Right now the fact that attnum presents the logical order but
> not the logical position is a problem for the JDBC driver.
> In the presence of dropped columns there is no easy way to
> get from a pg_attribute entry to logical position.  I would
> hope that a new logical position column would reflect the
> actual position and solve this problem.

I agree, I haven't thought of drop column :-( Drop column should have
relabeled attnum.
Since it was not done then, my comments are probably moot.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: What is CheckPoint.undo needed for?
Next
From: Alvaro Herrera
Date:
Subject: Re: SCMS question