Re: Updated ALTER TABLE ... SET TABLESPACE patch

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Updated ALTER TABLE ... SET TABLESPACE patch
Дата
Msg-id 40EDF4FC.5060700@familyhealth.com.au
обсуждение исходный текст
Ответ на Updated ALTER TABLE ... SET TABLESPACE patch  (Gavin Sherry <swm@linuxworld.com.au>)
Ответы Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
> Attached is an updated ALTER TABLE ... SET TABLESPACE patch.
>
> It uses the block by block copy mechanism proposed by Tom and handles i)
> ALTER TABLE <index> .... and ii) Copying of TOAST tables and the TOAST
> table's index.
>
> It doesn't handle copying of system tables (pg_largeobject) and, in the
> interests of code reuse, the patch fiddles with the code used by CLUSTER.
> This isn't great but I wanted to get a patch in before 1 July since I
> think the feature is very important -- even for the first release.

Does this patch allow setting the tablespace of sequences as well?  If
so, then you will need to modify pg_dump of SERIAL sequences.  Perhaps
output a ALTER TABLE/SET TABLESPACE command after the CREATE TABLE
definition to move the SERIAL sequence.

The same argument applies if it allows moving indexes. (Unique and
Primary Keys)

Chris

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

Предыдущее
От: "Walter"
Дата:
Сообщение: Re: Digital Mars C++ - Clients
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Digital Mars C++ - Clients