Skip site navigation (1) Skip section navigation (2)

postgres [table name] [IP] idle in transaction ?

From: "Rashmi Maheshwari" <rashmi(dot)maheshwari(at)impetus(dot)co(dot)in>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: postgres [table name] [IP] idle in transaction ?
Date: 2005-05-25 05:51:10
Message-ID: 01fa01c560ed$c075abe0$7561a8c0@impetus.co.in (view raw or flat)
Thread:
Lists: pgsql-ports
hello 

i am using postgres with J2EE application 
after running the postgres , when access the tables of a databse  from a PC , a process becomes Idle . although operation goes on .. when access same table from another pc by same user , again a process becomes idle .. but second time when access from same PC . or perform Same operation from Same PC , no transaction become idle .. 
why first time access makes transaction idle.. 
Please suggesst some reasons and thier solun also 

eg
     postgres eis [IP of PC1 ] idle in transaction
     postgres eis [IP of PC2 ] idle in transaction

Thanks and Regards 
Rashmi Maheshwari

pgsql-ports by date

Next:From: ULODate: 2005-05-25 06:54:24
Subject: изготовление печатной продукции
Previous:From: 6 июня МосваDate: 2005-05-25 03:59:53
Subject: передайте главному бухгалтеру

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group