Re: ALTER TABLESPACE ... MOVE ALL TO ...

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: ALTER TABLESPACE ... MOVE ALL TO ...
Дата
Msg-id 20140120160253.GL31026@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: ALTER TABLESPACE ... MOVE ALL TO ...  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
* Simon Riggs (simon@2ndQuadrant.com) wrote:
> > ALTER TABLESPACE name MOVE OWNED TO name opt_nowait
>
> The ALL seems to have value. "MOVE ALL OWNED TO" sounds better.

I could go either way on this, really.

> > ALTER TABLESPACE name MOVE TABLES OWNED TO name opt_nowait
> > ALTER TABLESPACE name MOVE INDEXES OWNED TO name opt_nowait
>
> On those two, I think the docs need to be clearer that we mean that
> TABLES means tables, and yes we leave the indexes behind. Or that
> INDEXES means "and we leave the tables behind. This is intended to
> more easily separate tables and indexes into their own tablespaces."
> or similar.

Sure, I can certainly improve the documentation on that.

> I'm not clamouring for squeezing additional goodies from you, just to
> make a small change to avoid later confusion (for ALL users ;-) )

:)  What are your thoughts on what I just proposed to Tom?

> Good feature, thanks for working on it.
Thanks!
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: ALTER TABLESPACE ... MOVE ALL TO ...
Следующее
От: Antonin Houska
Дата:
Сообщение: Re: Backup throttling