Re: [PATCH] ALTER TABLE ... SET STORAGE default

Nikita Malakhov <hukutoc@gmail.com>

From: Nikita Malakhov <hukutoc@gmail.com>
To: Aleksander Alekseev <aleksander@timescale.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2022-08-22T13:15:39Z
Lists: pgsql-hackers
Hi hackers!

This seems a little bit confusing and thus very unfriendly for the user,
because the actual meaning
of the same 'DEFAULT' option will be different for each data type, and
to check storage mode user
has to query full table (or column) description.
I'd rather add a paragraph in documentation describing each data type
default storage mode.

On Mon, Aug 22, 2022 at 3:34 PM Aleksander Alekseev <
aleksander@timescale.com> wrote:

> Hi hackers,
>
> I noticed that we support 'ALTER TABLE ... SET COMPRESSION default'
> syntax, but not 'SET STORAGE default' which seems to be a bit
> inconsistent. When the user changes the storage mode for a column
> there is no convenient way to revert the change.
>
> The proposed patch fixes this.
>
> --
> Best regards,
> Aleksander Alekseev
>


-- 
Regards,
Nikita Malakhov
https://postgrespro.ru/

Commits

  1. Support writing "CREATE/ALTER TABLE ... SET STORAGE DEFAULT".