>>On Wed, Apr 06, 2011 at 09:12:55AM -0500, Davenport, Julie wrote: >> 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.
>What if you stop your connection? This sounds like under 8.0 you were >closing the connection (thereby ending a session), but that under 8.4 >your connection isn't actually closing (so your session remains open, >so the temp table hangs around). > >A > >-- <Andrew Sullivan <ajs(at)crankycanuck(dot)ca We've never explicitly closed the connection, it just seemed to close automatically when the coldfusion script ended. Not sure how I would even do that from a script since this is run automatically, not from the command line. Other than putting a quit inside a cfquery tag? Thanks, Julie julie.davenp...@ctcd.edu
