| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| 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-11 23:17:25 |
| Message-ID: | 1826.1089587845@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-07-11 23:20:08 | Re: Updated ALTER TABLE ... SET TABLESPACE patch |
| Previous Message | Bruce Momjian | 2004-07-11 22:52:34 | Re: possibly updating techdocs; mysql2pgsql on gborg |