Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] ALTER TABLE ... SET STORAGE default - Mailing list pgsql-hackers

From Nikita Malakhov
Subject Re: [PATCH] ALTER TABLE ... SET STORAGE default
Date
Msg-id CAN-LCVM1J-W5vRZGdtHAc+Drj+eQGYVsWBB6pU19sBYrW0RzJw@mail.gmail.com
Whole thread Raw
In response to [PATCH] ALTER TABLE ... SET STORAGE default  (Aleksander Alekseev <aleksander@timescale.com>)
Responses Re: [PATCH] ALTER TABLE ... SET STORAGE default
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: "kuroda.hayato@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply
Next
From: Aleksander Alekseev
Date:
Subject: Re: [PATCH] ALTER TABLE ... SET STORAGE default