Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'

-- Start of PGP signed section.
> >>>>> "Bruce" == Bruce Momjian <maillist@candle.pha.pa.us> writes:
> 
>     Bruce> Yes.  There are going to be limitations to the temp tables.
>     Bruce> Not sure how what the limitations are going to be..
> 
> As a possible suggestion...I know Sybase requires that temp tables
> have names that begin with a `#'.  This avoids the problem of
> shadowing ordinary names.

That's cheezy.  Here is my latest temp trick.  Create a table and index,
create temp versions, insert into them, and test temp table removal. 
This is the regression test.  I am about to commit the code.

---------------------------------------------------------------------------QUERY: CREATE TABLE temptest(col int);QUERY:
CREATEINDEX i_temptest ON temptest(col);QUERY: CREATE TEMP TABLE temptest(col int);QUERY: CREATE INDEX i_temptest ON
temptest(col);QUERY:DROP INDEX i_temptest;QUERY: DROP TABLE temptest;QUERY: DROP INDEX i_temptest;QUERY: DROP TABLE
temptest;QUERY:CREATE TABLE temptest(col int);QUERY: INSERT INTO temptest VALUES (1);QUERY: CREATE TEMP TABLE
temptest(colint);QUERY: INSERT INTO temptest VALUES (2);QUERY: SELECT * FROM temptest;col---  2(1 row)QUERY: DROP TABLE
temptest;QUERY:SELECT * FROM temptest;col---  1(1 row)QUERY: DROP TABLE temptest;QUERY: CREATE TEMP TABLE temptest(col
int);--restarts backend\connect regression QUERY: SELECT * FROM temptest;ERROR:  temptest: Table does not exist.
 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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