We recently upgraded postgres from 7.3 to 7.4, along with the JDBC jar,
and noticed all the backend processes/connections are left in the "idle
in transaction" state where before they where left in the "idle" state.
Has something changed in the 7.4 jdbc driver vs 7.3 which might be
We call setAutoCommit(FALSE) on every connection when created.
Senior Vice President
Security Lending Wholesale, LC
pgsql-admin by date
|Next:||From: Soeren Laursen||Date: 2004-02-15 16:53:44|
|Subject: Re: idle in transaction|
|Previous:||From: luohao||Date: 2004-02-15 12:45:09|
|Subject: PostgreSQL 7.4.1 under Windows/cygwin: initdb fails with error|