Обсуждение: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Tom Lane wrote:
> Philip Warner <pjw@rhyme.com.au> writes:
> > On the question of schemas, how would you expect:
> >          SET magic_tablespace_variable = some_ts;
> >           CREATE SCHEMA foo;
> > to behave? Would foo have a default tablespace of some_ts?
> 
> Yeah, I would think so.  I sure don't see a value in inventing two
> different magic_tablespace_variables for tables and schemas ...

Now that I think of it, if we used 'SET magic_tablespace_variable' for
schemas and tables/indexes we could avoid the non-standard TABLESPACE
clause in CREATE TABLE.

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