diff options
| author | Stephen Frost <sfrost@snowman.net> | 2014-01-18 18:56:40 -0500 |
|---|---|---|
| committer | Stephen Frost <sfrost@snowman.net> | 2014-01-18 18:56:40 -0500 |
| commit | 76e91b38ba64e1da70ea21744b342cb105ea3400 (patch) | |
| tree | bc485da708d31d5484d5a3de6489cf73684a9640 /src/backend/tcop/utility.c | |
| parent | 6f25c62d788ea6312fe718ed57a3d169d8efc066 (diff) | |
| download | postgresql-76e91b38ba64e1da70ea21744b342cb105ea3400.tar.gz postgresql-76e91b38ba64e1da70ea21744b342cb105ea3400.zip | |
Add ALTER TABLESPACE ... MOVE command
This adds a 'MOVE' sub-command to ALTER TABLESPACE which allows moving sets of
objects from one tablespace to another. This can be extremely handy and avoids
a lot of error-prone scripting. ALTER TABLESPACE ... MOVE will only move
objects the user owns, will notify the user if no objects were found, and can
be used to move ALL objects or specific types of objects (TABLES, INDEXES, or
MATERIALIZED VIEWS).
Diffstat (limited to 'src/backend/tcop/utility.c')
| -rw-r--r-- | src/backend/tcop/utility.c | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/backend/tcop/utility.c b/src/backend/tcop/utility.c index 36cf72d05fb..f4d25bd1edd 100644 --- a/src/backend/tcop/utility.c +++ b/src/backend/tcop/utility.c @@ -243,6 +243,7 @@ check_xact_readonly(Node *parsetree) case T_AlterUserMappingStmt: case T_DropUserMappingStmt: case T_AlterTableSpaceOptionsStmt: + case T_AlterTableSpaceMoveStmt: case T_CreateForeignTableStmt: case T_SecLabelStmt: PreventCommandIfReadOnly(CreateCommandTag(parsetree)); @@ -548,6 +549,11 @@ standard_ProcessUtility(Node *parsetree, AlterTableSpaceOptions((AlterTableSpaceOptionsStmt *) parsetree); break; + case T_AlterTableSpaceMoveStmt: + /* no event triggers for global objects */ + AlterTableSpaceMove((AlterTableSpaceMoveStmt *) parsetree); + break; + case T_TruncateStmt: ExecuteTruncate((TruncateStmt *) parsetree); break; @@ -1822,6 +1828,10 @@ CreateCommandTag(Node *parsetree) tag = "ALTER TABLESPACE"; break; + case T_AlterTableSpaceMoveStmt: + tag = "ALTER TABLESPACE"; + break; + case T_CreateExtensionStmt: tag = "CREATE EXTENSION"; break; @@ -2514,6 +2524,10 @@ GetCommandLogLevel(Node *parsetree) lev = LOGSTMT_DDL; break; + case T_AlterTableSpaceMoveStmt: + lev = LOGSTMT_DDL; + break; + case T_CreateExtensionStmt: case T_AlterExtensionStmt: case T_AlterExtensionContentsStmt: |