Postgres Pro
Downloads
Home   >   mailing lists

Re: IDLE IN TRANSACTION - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: IDLE IN TRANSACTION
Date
Msg-id 200604191436.42770.peter_e@gmx.net
Whole thread Raw
In response to IDLE IN TRANSACTION  ("Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>)
List pgsql-admin
Tree view 
Rodrigo Sakai wrote:
> But I want to know if this kind of connection (idle in
> transaction) can cause locks and deadlocks on the db?

Certainly.  Make sure the application is closing the transactions
quickly.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: "Andy Shellam"
Date:
Subject: Re: IDLE IN TRANSACTION
Next
From: Stephan Szabo
Date:
Subject: Re: Different results when specifying DEFAULT values through