Re: Tablespace patch review - Mailing list pgsql-patches

From Tom Lane
Subject Re: Tablespace patch review
Date
Msg-id 16336.1087541816@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tablespace patch review  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Tablespace patch review  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I have a few other questions:

> What is the procedure for moving tablespace directories?

There is none.

> However, pg_tablespace still has the old location.

Yup.  The *only* thing that pg_tablespace.spclocation is used for is
for pg_dumpall to dump appropriate CREATE TABLESPACE commands, so it's
not like you couldn't hack it after the fact.

> Do we need ALTER TABLESPACE to move tablespaces, and ALTER clauses to
> move objects to other tablespaces?  Are these TODO items for later?

TODO.  You sound like a man who's expecting a
several-generations-polished facility when we only just committed
the first version today.  I do not feel a need to have any of these
features in 7.5 ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tablespace patch review
Next
From: Gavin Sherry
Date:
Subject: Re: Tablespace patch review