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