pgsql: Allow ALTER TABLE name {OF type | NOT OF}. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Allow ALTER TABLE name {OF type | NOT OF}.
Date
Msg-id E1QCjDD-0001U1-Lz@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Allow ALTER TABLE name {OF type | NOT OF}.  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-committers
Allow ALTER TABLE name {OF type | NOT OF}.

This syntax allows a standalone table to be made into a typed table,
or a typed table to be made standalone.  This is possibly a mildly
useful feature in its own right, but the real motivation for this
change is that we need it to make pg_upgrade work with typed tables.
This doesn't actually fix that problem, but it's necessary
infrastructure.

Noah Misch

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/68739ba856c52e6721d6cffec21f1bf0327a9a7b

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml         |   26 +++
src/backend/commands/tablecmds.c          |  277 +++++++++++++++++++++++++++--
src/backend/parser/gram.y                 |   17 ++
src/backend/parser/parse_utilcmd.c        |   22 +---
src/include/commands/tablecmds.h          |    2 +
src/include/nodes/parsenodes.h            |    2 +
src/test/regress/expected/alter_table.out |   38 ++++
src/test/regress/sql/alter_table.sql      |   30 +++
8 files changed, 376 insertions(+), 38 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix bugs in indexing of in-doubt HOT-updated tuples.
Next
From: Robert Haas
Date:
Subject: pgsql: Typo fix.