Re: Reordering the fields in a table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reordering the fields in a table
Дата
Msg-id 257889.1618674030@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reordering the fields in a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Reordering the fields in a table
Следующее
От: Yambu
Дата:
Сообщение: Recovered data directory