Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html' - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
Date
Msg-id 199902020302.WAA08573@candle.pha.pa.us
Whole thread Raw
In response to Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'  (Roland Roberts <roberts@panix.com>)
List pgsql-hackers
-- 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
 


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: [GENERAL] big bad join problems
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Optimizer speed and GEQO (was: nested loops in joins)