Re: Column storage positions - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: Column storage positions
Date
Msg-id Pine.BSO.4.64.0702221310460.11771@leary.csoft.net
Whole thread Raw
In response to Re: Column storage positions  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Responses Re: Column storage positions  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers

On Thu, 22 Feb 2007, Zeugswetter Andreas ADI SD wrote:

> 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.

Kris Jurka


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: tsearch in core patch, for inclusion
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: SCMS question