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                        |
  [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?


Reply via email to