Re: IDLE IN TRANSACTION

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org, "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
Subject: Re: IDLE IN TRANSACTION
Date: 2006-04-19 12:36:41
Message-ID: 200604191436.42770.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message danish.siddiqui@hovservices.com 2006-04-19 13:26:19 tomcat postgresql database conectivity error
Previous Message Andy Shellam 2006-04-19 12:05:06 Re: IDLE IN TRANSACTION