Re: logical column position

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Neil Conway <neilc(at)samurai(dot)com>, Jon Jensen <jon(at)endpoint(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: logical column position
Date: 2003-11-18 03:15:11
Message-ID: 20031117191140.X15470@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Tue, 18 Nov 2003, Peter Eisentraut wrote:

> Christopher Kings-Lynne writes:
>
> > BTW, one main consideration is that all the postgres admin apps will now
> > need to support ORDER BY attlognum for 7.5+.
>
> But that is only really important if they've also used the ALTER TABLE
> RESHUFFLE COLUMNS feature. So if they make one alteration for 7.5, they
> need to do another. That seems fair.

The ability to reshuffle and to get the correct ordering in a client app
are separate unless we're going to assume that all access goes through
that particular client. If one user uses psql and shuffles them, a
second user using fooclient may not see the new ordering.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Brown 2003-11-18 03:21:23 Re: Release cycle length
Previous Message Christopher Kings-Lynne 2003-11-18 03:10:25 Re: logical column position