Re: Revisiting ALTER COLUMN POSITION support

Hello Daniel,

On 2025-Nov-28, Daniel Cyran wrote:

> I'd like to reopen the discussion about adding support for reorderable
> columns (e.g. ALTER COLUMN POSITION or ALTER COLUMN ... AFTER ...).

Yeah, I've been planning to work on this after completing the REPACK
project -- I have an old patch for this that I need to rebase and
complete. I suspect it has become substantially harder now that the
backend has moved forward 10 years. I suspect it's going to be quite
challenging.
https://postgr.es/m/20141209174146.GP1768@alvh.no-ip.org

Somebody else also tried to work on this a couple of years ago, but I
think they got discouraged or something (most likely because of us
moving the goalposts or whatever).
https://postgr.es/m/20220628083230.c4qhp4fdp3dp22ig%40jrouhaud

Regards

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"I can see support will not be a problem. 10 out of 10." (Simon Wittber)
(http://archives.postgresql.org/pgsql-general/2004-12/msg00159.php)