Re: Column storage positions

From: Kris Jurka <books(at)ejurka(dot)com>
To: Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>
Cc: Phil Currier <pcurrier(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Column storage positions
Date: 2007-02-22 18:13:07
Message-ID: Pine.BSO.4.64.0702221310460.11771@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2007-02-22 18:18:18 Re: SCMS question
Previous Message Pavel Stehule 2007-02-22 18:11:33 Re: tsearch in core patch, for inclusion