Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Fabien COELHO <coelho@cri.ensmp.fr> writes:
> It seems to me that the current implementation is not completed. For
> instance, do you expect someone to be able to remove a tablespace?

Not when it still contains objects.

> At the
> time it is not always possible, because all objects cannot be moved away
> from a tablespace (namely sequence, as it is considered useless to move
> them, what looks true from a performance perspective, but not from an
> administrator perspective).

The sequences are in the same tablespace as the system catalogs of the
database they are in, so this objection is moot.  (And no, we are not
accepting any suggestions about an ALTER command to relocate pg_class
on the fly...)
        regards, tom lane