Re: "Idle in Transaction" revisited.

Tom Lane wrote:
> "John R Pierce" <pierce@hogranch.com> writes:
>
>>We've been running into a *lot* of problems with "Idle in Transaction"
>>threads causing long term blockage of VACUUM's ability to free up dead rows.
>
>
> Yeah, that's from prematurely issuing BEGIN.  I believe there's a
> solution for this in the most recent JDBC driver versions --- but
> I dunno if it's in any official releases yet.

The "development driver" versions on jdbc.postgresql.org have this fixed
as part of the V3 overhaul. I'm not sure about the driver that's in the
7.4 tree.

-O