Re: Updated ALTER TABLE ... SET TABLESPACE patch

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Date: 2004-07-12 01:38:18
Message-ID: 40F1EB8A.9020502@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-07-12 01:56:31 Re: Updated ALTER TABLE ... SET TABLESPACE patch
Previous Message Bruce Momjian 2004-07-12 01:34:17 Re: FW: Initdb patch