Re: Updated ALTER TABLE ... SET TABLESPACE patch
| От | Tom Lane |
|---|---|
| Тема | Re: Updated ALTER TABLE ... SET TABLESPACE patch |
| Дата | |
| Msg-id | 1826.1089587845@sss.pgh.pa.us обсуждение |
| Ответ на | Re: Updated ALTER TABLE ... SET TABLESPACE patch (Christopher Kings-Lynne <chriskl@familyhealth.com.au>) |
| Ответы |
Re: Updated ALTER TABLE ... SET TABLESPACE patch
Re: Updated ALTER TABLE ... SET TABLESPACE patch |
| Список | pgsql-patches |
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Attached is an updated ALTER TABLE ... SET TABLESPACE patch.
> 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)
Sequences no, toast tables no, indexes yes. So we need the
latter part of the above-mentioned patch. Anyone?
regards, tom lane
В списке pgsql-patches по дате отправления: