OSDN Git Service

Allow ALTER TABLE name {OF type | NOT OF}.
authorRobert Haas <rhaas@postgresql.org>
Thu, 21 Apr 2011 01:35:15 +0000 (21:35 -0400)
committerRobert Haas <rhaas@postgresql.org>
Thu, 21 Apr 2011 01:38:47 +0000 (21:38 -0400)
commit68739ba856c52e6721d6cffec21f1bf0327a9a7b
treef0982dcba2eb0414a732582e29ae03995636a6fb
parent520bcd9c9bb4d06627054e1c567bac1feb2da879
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
doc/src/sgml/ref/alter_table.sgml
src/backend/commands/tablecmds.c
src/backend/parser/gram.y
src/backend/parser/parse_utilcmd.c
src/include/commands/tablecmds.h
src/include/nodes/parsenodes.h
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql