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