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

Fabien COELHO <fabien(dot)coelho(at)ensmp(dot)fr> writes:
>> The sequences are in the same tablespace as the system catalogs of the
>> database they are in, so this objection is moot.

> three (unusual?) commands to reach the "moot" state:

> psql> CREATE TABLESPACE foo LOCATION '/tmp/postgres';
> psql> CREATE SCHEMA bla TABLESPACE foo;
> 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. The intention was that sequences would always be
in the database default tablespace. I'm not sure why this case is
overriding that ... but we can fix it.

regards, tom lane