From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Reordering the fields in a table
Date: Sat, 17 Apr 2021 11:40:30 -0400
Message-ID: <257889.1618674030@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwZ+fnqh=jYYo6BkvVzrf66p4FCKokJh0eXi7yHQTnKV=Q@mail.gmail.com>
References: <SN6PR11MB332652C8CA57B27E80EF9FBDDE4C9@SN6PR11MB3326.namprd11.prod.outlook.com>
<d3bd1525612fe9784b66d313755947a9284e4ef9.camel@cybertec.at>
<ef3e9b95-719c-c37a-822e-82bf8d5b74af@gmail.com>
<CAKFQuwZ+fnqh=jYYo6BkvVzrf66p4FCKokJh0eXi7yHQTnKV=Q@mail.gmail.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Reordering the fields in a table
In-Reply-To: <257889.1618674030@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox