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: | Raw Message | Whole Thread | 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 |
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 |
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... |