Possible Bug regarding temp tables (sql or psql?)

From: Mark Frazer <mark(at)somanetworks(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-interfaces(at)somanetworks(dot)com
Subject: Possible Bug regarding temp tables (sql or psql?)
Date: 2002-07-03 20:59:03
Message-ID: 20020703165903.A17844@somanetworks.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

When using the attached script in psql, the temp variables disappear as
far as \distv shows, but running the script a second time fails.

To reproduce, save the following script as bug.sql, then start psql on an
test database.
\i bug.sql
\distv
-- no relations should be shown
\i bug.sql
-- this will fail.

However, if you run psql again, you can
\i bug.sql
successfully. It will only fail if run twice in the same script.

cheers
-mark

--
Hardy Boys: too easy. Nancy Drew: too hard! - Fry

Attachment Content-Type Size
bug.sql text/plain 537 bytes

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Mark Frazer 2002-07-03 21:12:32 Re: Possible Bug regarding temp tables (sql or psql?)
Previous Message Thomas Graf 2002-07-03 20:55:35 Re: odbc

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Frazer 2002-07-03 21:12:32 Re: Possible Bug regarding temp tables (sql or psql?)
Previous Message Bruce Momjian 2002-07-03 20:22:04 Re: Selecting data from a table created in another database...