Re: ALTER COLUMN/logical column position

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pg(at)fastcrypt(dot)com, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER COLUMN/logical column position
Date: 2003-11-20 09:40:21
Message-ID: 3FBC8C05.6010507@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:

>
>attnum is used internally to retrieve the data
>
>
>
Oops...

So if an additional column number is invented, it should not be a
logical column number, but a physical storage number for internal data
retrieval. This way, the "user interface" doesn't change, and all those
"SELECT ... FROM pg_attribute ORDER BY attnum" continue delivering the
expected result.

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message strk 2003-11-20 10:23:09 Re: PG7.4 ordering operator
Previous Message Peter Eisentraut 2003-11-20 09:33:14 Re: [HACKERS] XML Docbook