Re: Reordering the fields in a table - Mailing list pgsql-admin

From Tom Lane
Subject Re: Reordering the fields in a table
Date
Msg-id 257889.1618674030@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reordering the fields in a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> The feature has been discussed before on these lists and the only thing
> preventing its inclusion is some developers either donating their time to
> see it finished or some interested non-developers paying some developers to
> write it on their behalf.

It's not just whether somebody finishes a patch.  The real concern
here is that separating logical from physical column order would
inevitably cause great quantities of bugs, probably including some
on the client side.  If our experience with dropped columns is any
guide, it'd probably take *years* to flush out all the places that
misbehave when dealing with re-ordered columns.  So maybe it'll
happen eventually, but it'll be far from pain-free.

(FWIW, I recall that Alvaro Herrera had a semi-finished patch
in this area a few years ago.  If anyone is interested in
pursuing this, starting from that would likely be useful.)

            regards, tom lane



pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Reordering the fields in a table
Next
From: Yambu
Date:
Subject: Recovered data directory