X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (mx2.hub.org [200.46.204.254])
	by postgresql.org (Postfix) with ESMTP id 72F1611F664C
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Apr 2006 08:59:20 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: -1.255
X-Spam-Level: 
X-Spam-Status: No, score=-1.255 required=5 tests=[AWL=-1.277, BAYES_05=-1.11,
	HTML_50_60=0.134, HTML_MESSAGE=0.001, SUBJ_ALL_CAPS=0.997]
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024)
	with ESMTP id 6-7iBd+j5mV6
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Apr 2006 08:59:19 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85])
	by postgresql.org (Postfix) with ESMTP id E7CD211F6612
	for <pgsql-admin@postgresql.org>; Wed, 19 Apr 2006 08:59:16 -0300 (ADT)
Received: from cprsakai ([192.168.0.71])
	by mail.zanthus.com.br (8.13.4/8.13.4/Debian-3) with SMTP id
	k3JC0vxN029421
	for <pgsql-admin@postgresql.org>; Wed, 19 Apr 2006 09:00:57 -0300
Message-ID: <004101c663a8$c5e65520$4700a8c0@TREEZANTHUS>
Reply-To: "Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>
From: "Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>
To: <pgsql-admin@postgresql.org>
Subject: IDLE IN TRANSACTION
Date: Wed, 19 Apr 2006 08:59:54 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_003E_01C6638F.A01F8050"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
X-Zanthus-MailScanner: Found to be clean
X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br
X-Archive-Number: 200604/180
X-Sequence-Number: 21349

This is a multi-part message in MIME format.

------=_NextPart_000_003E_01C6638F.A01F8050
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

  Hi,=20

  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!
------=_NextPart_000_003E_01C6638F.A01F8050
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1528" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&nbsp; Hi, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; I have an app developed with =
Delphi, and=20
when I just start tha app it start a process (a connection)&nbsp;on the =
db=20
server and the status stay 'IDLE IN TRANSACTION' until the end of the=20
application. The app is developed by other people and I don't know much =
about=20
how it was programmed! But I want to know if this kind of connection =
(idle in=20
transaction) can cause locks and deadlocks on the db? And if is there a =
better=20
way to connect to db?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Thanks in=20
advance!</FONT></DIV></BODY></HTML>

------=_NextPart_000_003E_01C6638F.A01F8050--