pgsql: Allow specifying STORAGE attribute for a new table

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Allow specifying STORAGE attribute for a new table
Date: 2022-07-13 10:28:27
Message-ID: E1oBZbV-002a3L-ID@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow specifying STORAGE attribute for a new table

Previously, the STORAGE specification was only available in ALTER
TABLE. This makes it available in CREATE TABLE as well.

Also make the code and the documentation for STORAGE and COMPRESSION
attributes consistent.

Author: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Author: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Reviewed-by: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Reviewed-by: wenjing zeng <wjzeng2012(at)gmail(dot)com>
Reviewed-by: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Reviewed-by: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Discussion: https://postgr.es/m/de83407a-ae3d-a8e1-a788-920eb334f25b@sigaev.ru

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/784cedda0604ee4ac731fd0b00cd8b27e78c02d3

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 2 +-
doc/src/sgml/ref/create_table.sgml | 29 +++++++++-
src/backend/commands/tablecmds.c | 92 +++++++++++++++++--------------
src/backend/parser/gram.y | 24 +++++---
src/include/nodes/parsenodes.h | 1 +
src/test/regress/expected/alter_table.out | 6 +-
src/test/regress/sql/alter_table.sql | 5 +-
7 files changed, 107 insertions(+), 52 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2022-07-13 11:00:07 pgsql: Fix flag tests in src/test/modules/test_oat_hooks
Previous Message Peter Eisentraut 2022-07-13 10:17:31 Re: pgsql: Fix for make unportability