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

* Simon Riggs (simon(at)2ndQuadrant(dot)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