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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Дата
Msg-id 7923.1093883739@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Следующее
От: Robert Treat
Дата:
Сообщение: Re: psql questions: SQL, progname, copyright dates