From: Bruce Momjian <maillist@candle.pha.pa.us>
To: roberts@panix.com
Cc: hackers@postgreSQL.org
Cc: docs@postgreSQL.org
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
Date: Mon, 1 Feb 1999 22:02:02 -0500 (EST)
Message-ID: <199902020302.WAA08573@candle.pha.pa.us> (raw)
In-Reply-To: <m390ehh7mk.fsf@tycho.rlent.pnet>
-- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: maillist@candle.pha.pa.us, roberts@panix.com, hackers@postgreSQL.org, docs@postgreSQL.org
Subject: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
In-Reply-To: <199902020302.WAA08573@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox