Horton

[PATCH] ALTER TABLE ... SET STORAGE default

Aleksander Alekseev <aleksander@timescale.com>

View thread View on postgr.es
From: Aleksander Alekseev <aleksander@timescale.com>
To: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2022-08-22T12:34:25Z
Lists: pgsql-hackers

Attachments

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

Commits

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