Tom Lane wrote:
> Christopher Kings-Lynne <chriskl@familyhealth.com.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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
