Re: IDLE IN TRANSACTION

No problem really, all it means is the application has issued a start of
transaction command, it just isn't doing anything at the moment.

Transactions allow any data added during the application's running to be
rolled back should, for example, the application crash - it'll prevent
half-written data remaining stale in your database.

My guess is when you Exit the application correctly, it'll issue a COMMIT
statement to store the transactional data to your database.

_____

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Rodrigo Sakai
Sent: 19 April 2006 1:00 pm
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] IDLE IN TRANSACTION

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!

!DSPAM:14,4446269633691691718838!