Possible Bug regarding temp tables (sql or psql?) - Mailing list pgsql-sql

From Mark Frazer
Subject Possible Bug regarding temp tables (sql or psql?)
Date
Msg-id 20020703165903.A17844@somanetworks.com
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Selecting data from a table created in another database...
Next
From: Stephan Szabo
Date:
Subject: Re: How do I access the current row from a trigger?