Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: roberts(at)panix(dot)com (Roland Roberts)
Cc: hackers(at)postgreSQL(dot)org, docs(at)postgreSQL(dot)org
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
Date: 1999-02-02 03:02:02
Message-ID: 199902020302.WAA08573@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
-- 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

In response to

pgsql-docs by date

Next:From: Thomas G. LockhartDate: 1999-02-02 03:30:24
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
Previous:From: Roland RobertsDate: 1999-02-02 02:17:07
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-02-02 03:02:31
Subject: Re: [HACKERS] Re: [GENERAL] big bad join problems
Previous:From: Bruce MomjianDate: 1999-02-02 02:58:32
Subject: Re: [HACKERS] Small patches in copy.c and trigger.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group