Horton

Re: REPACK and naming

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-17T12:04:19Z
Lists: pgsql-hackers 
Em ter., 16 de set. de 2025 às 23:01, Robert Haas <robertmhaas@gmail.com>
escreveu:

> I think RETABLE is not a proposal to be taken seriously. That's
> extremely confusing.
>

This feature could be used in a future version to rearrange fields in a
table, for better padding.
I don't think we have another one available for this purpose.

CREATE TABLE T(A text, B integer, C bigint, D integer);

We could have something like
RETABLE T USING(B, D, C, A)

So REPACK isn't the best for this, if this feature would exist some day.

regards
Marcos