Postgres Pro
Downloads
Home   >   mailing lists

IDLE IN TRANSACTION - Mailing list pgsql-admin

From Rodrigo Sakai
Subject IDLE IN TRANSACTION
Date
Msg-id 004101c663a8$c5e65520$4700a8c0@TREEZANTHUS
Whole thread Raw
Responses Re: IDLE IN TRANSACTION  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Re: IDLE IN TRANSACTION  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Tree view
  Hi,
 
  I have an app developed with Delphi, and when I just start tha app it start a process (a connection) on the db server and the status stay 'IDLE IN TRANSACTION' until the end of the application. The app is developed by other people and I don't know much about how it was programmed! But I want to know if this kind of connection (idle in transaction) can cause locks and deadlocks on the db? And if is there a better way to connect to db?
 
  Thanks in advance!

pgsql-admin by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: Migration from oracle
Next
From: "Andy Shellam"
Date:
Subject: Re: IDLE IN TRANSACTION