Re: [bulk] Re: [GENERAL] Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1

2011-06-08 Thread Merlin Moncure
On Wed, Jun 8, 2011 at 9:32 AM, Tarabas wrote: > Hello, > > the problem just resurfaced and the Wiki page dows not really help > very much. > > When i look into the pg_stat_activity, i only see that the connections > all state " in transaction". > > Is there any way to find out what the transactio

Re: [bulk] Re: [GENERAL] Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1

2011-06-08 Thread Tarabas
Hello, the problem just resurfaced and the Wiki page dows not really help very much. When i look into the pg_stat_activity, i only see that the connections all state " in transaction". Is there any way to find out what the transaction is doing exactly to be able to debug the Problem? Best regar