Re: SET variables

> > Wow, that really does stink.  I know Informix can't have a temp table
> > with the same name as a real table, and I thought that was bad, but
> > Oracle is much worse.
> >
> 
> Although....
> 
> One can see the advantage in a globally shared temporary table. For instance,
> something like user web session management. One can insert and update against
> the temp table and never have to worry about disk I/O or vacuuming. (Assuming a
> temp table is implemented as a memory buffer)

Yes, but having a temp table never hit disk is a different issue from
its visibility.  We could eventually implement the memory-only feature
if we wanted to.  Right now, we have it dumping to disk as a backing
store for the table, assuming it wouldn't fit all in memory.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026