Hi folks,

Hoping someone can shed some light here.

I have a web application that I'm developing under Tomcat 5.x using Hibernate 3 against a Postgresql 8.2 server. What I'm seeing happen is after a few "visits" to the web site I see in the Unix process table a lot of Postgres postmater processes running that are in a "idle in transaction" state.

Since I am in the development phase of my project this becomes a problem when I try to modify my schema. Dropping and recreating tables "hangs" the psql client when those processes exist.

My JDBC driver is postgresql-8.2dev-500.jdbc2.jar which I got from the Postgresql web site a while back.

Any thoughts on this matter would be greatly appreciated.