-- 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