|
>>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.davenport@xxxxxxxx |
