Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Date
Msg-id 7923.1093883739@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Next
From: Robert Treat
Date:
Subject: Re: psql questions: SQL, progname, copyright dates