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

Dear Tom,

> >     psql> CREATE TABLE bla.boo(id SERIAL PRIMARY KEY);
>
> > Now you have schema bla, table bla.boo, index bla.boo_pkey and sequence
> > bla.boo_id_seq all in tablespace foo.
>
> Hmm, that's a bug.

If you consider that a bug, then you can also add: "CREATE SEQUENCE bla.sg;"

> The intention was that sequences would always be in the database default
> tablespace.  I'm not sure why this case is overriding that ...

It does what the doc says about schema tablespaces:
 "The name of the tablespace that is to be the default tablespace for all new objects created in the schema. If not
supplied,the schema will inherit the default tablespace of the database."
 

and that looks sound enough to me...

> but we can fix it.

Good.

-- 
Fabien Coelho - coelho@cri.ensmp.fr