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? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html