Rework 'MOVE ALL' to 'ALTER .. ALL IN TABLESPACE'
Stephen Frost <sfrost@snowman.net>
Rework 'MOVE ALL' to 'ALTER .. ALL IN TABLESPACE' As 'ALTER TABLESPACE .. MOVE ALL' really didn't change the tablespace but instead changed objects inside tablespaces, it made sense to rework the syntax and supporting functions to operate under the 'ALTER (TABLE|INDEX|MATERIALIZED VIEW)' syntax and to be in tablecmds.c. Pointed out by Alvaro, who also suggested the new syntax. Back-patch to 9.4.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_index.sgml | modified | +13 −0 |
| doc/src/sgml/ref/alter_materialized_view.sgml | modified | +2 −0 |
| doc/src/sgml/ref/alter_table.sgml | modified | +17 −3 |
| doc/src/sgml/ref/alter_tablespace.sgml | modified | +0 −78 |
| doc/src/sgml/release-9.4.sgml | modified | +4 −1 |
| src/backend/commands/tablecmds.c | modified | +171 −0 |
| src/backend/commands/tablespace.c | modified | +0 −179 |
| src/backend/nodes/copyfuncs.c | modified | +5 −6 |
| src/backend/nodes/equalfuncs.c | modified | +4 −5 |
| src/backend/parser/gram.y | modified | +68 −97 |
| src/backend/tcop/utility.c | modified | +8 −12 |
| src/include/commands/tablecmds.h | modified | +2 −0 |
| src/include/commands/tablespace.h | modified | +0 −1 |
| src/include/nodes/nodes.h | modified | +1 −1 |
| src/include/nodes/parsenodes.h | modified | +3 −4 |
| src/test/regress/input/tablespace.source | modified | +3 −2 |
| src/test/regress/output/tablespace.source | modified | +3 −2 |
| src/tools/pgindent/typedefs.list | modified | +1 −1 |