Re: postgresql idle

On Thu, Apr 29, 2004 at 03:57:59PM -0400, Andrew Rawnsley wrote:
>
>  I find that some clients (DBVisualizer for one) do exactly that -
> execute the COMMIT;BEGIN sequence, and leaves idle
> transactions on a consistent basis.

Almost all the things I've see that set the autocommit behaviour will
also do this.  I suspect it's a pretty common approach.  It has
burned us at work several times, and I knew in advance it was a
problem.  I can't imagine what it's like for people who aren't aware
of it.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca