Re: Updated ALTER TABLE ... SET TABLESPACE patch - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Updated ALTER TABLE ... SET TABLESPACE patch
Date
Msg-id 40F1EB8A.9020502@familyhealth.com.au
Whole thread Raw
In response to Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
>>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?

I'll do it.

Chris


pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Next
From: Bruce Momjian
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch