Thread: pgsql: Allow specifying STORAGE attribute for a new table

pgsql: Allow specifying STORAGE attribute for a new table

From
Peter Eisentraut
Date:
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@sigaev.ru>
Author: Aleksander Alekseev <aleksander@timescale.com>
Reviewed-by: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Reviewed-by: wenjing zeng <wjzeng2012@gmail.com>
Reviewed-by: Matthias van de Meent <boekewurm+postgres@gmail.com>
Reviewed-by: Kyotaro Horiguchi <horikyota.ntt@gmail.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(-)