Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> 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?
Added to TODO; * Allow moving sequences and toast tables to other tablespaces in case no one does it. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org