On 04/06/2011 08:12 AM, Davenport, Julie wrote:
Since we upgraded from postgres 8.0 to 8.4, every script where we have
queries that use temp tables now has to have an explicit drop of the
temp table at the end of the script, or it will blow up the next time it
runs, saying it cannot create the temp table because it already exists
(these are coldfusion 8 scripts running queries on postgres 8.4
database). When we get the error, if we try to drop the table at the
command line, it says the table does not exist, yet we cannot rerun the
script unless we stop and restart the database. This never happened with
pg 8.0, so the definition of “when a session ends” seems to have changed
(isn’t a temp table supposed to automatically disappear at the end of
the session)? Is there some easier or better way to clear these
temporary areas?
Thanks,
Julie
julie.davenp...@ctcd.edu
The connection running the script actually terminates?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
