Re: Updated ALTER TABLE ... SET TABLESPACE patch

Tom Lane wrote:
> 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?

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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073