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

Fabien COELHO wrote:
>
> 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...

Good point. If we put sequences in the database default location it
would be inconsistent with other object location, but this does bring up
the problem of being unable to move sequences to get rid of a
tablespace.

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