From: Andy Shellam <andy.shellam@mailnetwork.co.uk>
To: 'Rodrigo Sakai' <rodrigo.sakai@zanthus.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: IDLE IN TRANSACTION
Date: Wed, 19 Apr 2006 13:05:06 +0100
Message-ID: <20060419120510.B01C611F60B4@postgresql.org> (raw)
In-Reply-To: <004101c663a8$c5e65520$4700a8c0@TREEZANTHUS>
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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rodrigo Sakai
Sent: 19 April 2006 1:00 pm
To: pgsql-admin@postgresql.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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: andy.shellam@mailnetwork.co.uk, rodrigo.sakai@zanthus.com.br
Subject: Re: IDLE IN TRANSACTION
In-Reply-To: <20060419120510.B01C611F60B4@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox