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

-- Start of PGP signed section.
> >>>>> "Bruce" == Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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: CREATE INDEX 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(col int);
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026