I am experiencing a blocking situation in my database (Postgresql 8.1.8 on Redhat). When I do a "ps -ef|grep postgres" I see two processing that are "idle in transaction" and they stay there indefinitely. I'm running JBoss (the problem is in JBossMQ) and I'm having trouble pinpointing the location/cause of the block as JBoss doesn't report any errors or exceptions. It just sits there. Is there any way to increase the debug logging or issue a query so that I could find the actual select statements that are idle? That would help me isolate the source of my problem. Thanks
