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
-
Support writing "CREATE/ALTER TABLE ... SET STORAGE DEFAULT".
- b9424d014e19 16.0 landed