Alvaro Herrera wrote: > On Fri, Aug 20, 2004 at 01:26:39PM +1000, Philip Warner wrote: > > At 01:09 PM 20/08/2004, Tom Lane wrote: > > >It seemed like a reasonable idea to me... > > > > Do we have a "SET DEFAULT TABLESPACE"? Can we add one for this release? If > > not, we probably need to go with the ALTER TABLE. Although a SET DEFAULT > > TABLESPACE would be convenent in general. > > The problem with ALTER TABLE is that it can be hugely expensive, I think.
I was thinking that too, but I assume they are creating the table empty, moving it to another tablespace, then loading it. -- 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])