Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67])
	by hub.org (8.9.2/8.9.1) with ESMTP id WAA90492;
	Mon, 1 Feb 1999 22:01:59 -0500 (EST)
	(envelope-from maillist@candle.pha.pa.us)
Received: (from maillist@localhost)
	by candle.pha.pa.us (8.9.0/8.9.0) id WAA08573;
	Mon, 1 Feb 1999 22:02:02 -0500 (EST)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199902020302.WAA08573@candle.pha.pa.us>
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html
	main.html'
In-Reply-To: <m390ehh7mk.fsf@tycho.rlent.pnet> from Roland Roberts at "Feb 1,
	1999  9:17: 7 pm"
To: roberts@panix.com (Roland Roberts)
Date: Mon, 1 Feb 1999 22:02:02 -0500 (EST)
Cc: hackers@postgreSQL.org, docs@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL47 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

-- 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: 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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026