Thread: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

From
Christopher Kings-Lynne
Date:
> Now you have schema bla, table bla.boo, index bla.boo_pkey and sequence
> bla.boo_id_seq all in tablespace foo. ISTM that tablespace foo cannot be
> removed without hand-fixing pg_catalog and hand-moving files or links in
> the database directory.

Hmmm, I wonder why the tablespace is set to the foo tablespace for the 
sequence?  Sequences are supposed to always be created in the default 
tablespace.  Bug?