pgsql: Add ALTER TABLESPACE ... MOVE command

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add ALTER TABLESPACE ... MOVE command
Date: 2014-01-19 00:11:20
Message-ID: E1W4fyy-0002Hg-RN@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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).

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/76e91b38ba64e1da70ea21744b342cb105ea3400

Modified Files
--------------
doc/src/sgml/ref/alter_tablespace.sgml | 59 +++++++++-
src/backend/commands/tablespace.c | 171 +++++++++++++++++++++++++++++
src/backend/nodes/copyfuncs.c | 15 +++
src/backend/nodes/equalfuncs.c | 14 +++
src/backend/parser/gram.y | 46 +++++++-
src/backend/tcop/utility.c | 14 +++
src/include/commands/tablespace.h | 1 +
src/include/nodes/nodes.h | 1 +
src/include/nodes/parsenodes.h | 10 ++
src/include/parser/kwlist.h | 1 +
src/test/regress/input/tablespace.source | 7 +-
src/test/regress/output/tablespace.source | 8 +-
src/tools/pgindent/typedefs.list | 1 +
13 files changed, 340 insertions(+), 8 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-01-19 00:25:45 pgsql: Fix VACUUM's reporting of dead-tuple counts to the stats collect
Previous Message Stephen Frost 2014-01-18 23:51:12 pgsql: Allow SET TABLESPACE to database default

Browse pgsql-hackers by date

  From Date Subject
Next Message Marti Raudsepp 2014-01-19 00:14:32 [patch] Potential relcache leak in get_object_address_attribute
Previous Message Marko Tiikkaja 2014-01-18 23:44:01 Re: array_length(anyarray)