Tom Lane wrote: > Philip Warner <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend