Re: Tablespace issues (comment on ,moving indexes)

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: Tablespace issues (comment on ,moving indexes)
Дата
Msg-id 20040809214633.GC2544@filer
обсуждение исходный текст
Ответ на Re: Tablespace issues (comment on ,moving indexes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Tablespace issues (comment on ,moving indexes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Tablespace issues (comment on ,moving indexes)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> > 1. there is no COMMENT ON TABLESPACE support
> 
> That's right.
> 
> > 2. how is one supposed to move indexes(not tables) to another tablespace?
> 
> Use ALTER TABLE on the index.

Hmm...not ALTER INDEX?  Now that there's an operation that actually
modifies an index instead of the table itself, should there be an ALTER
INDEX?  It would be cleaner and more consistent, IMO...


-- 
Kevin Brown                          kevin@sysexperts.com


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

Предыдущее
От: pgsql@mohawksoft.com
Дата:
Сообщение: Re: fsync vs open_sync
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Beta Leader?