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?


Reply via email to