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(dot)davenport(at)ctcd(dot)edu