pgsql: Allow ALTER TABLE name {OF type | NOT OF}.
От | Robert Haas |
---|---|
Тема | pgsql: Allow ALTER TABLE name {OF type | NOT OF}. |
Дата | |
Msg-id | E1QCjDD-0001U1-Lz@gemulon.postgresql.org обсуждение исходный текст |
Ответы |
Re: pgsql: Allow ALTER TABLE name {OF type | NOT OF}.
|
Список | 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 по дате отправления: