Hi,
 
The query just returns "0 rows".
What else could be the problem?
 
Thanks,
Saranya
 


Steve Simms <steve at deefs.net> wrote:
On Tue, 4 Jan 2005, sarlav kumar wrote:

> Can you tell me how to check if there is some other connection holding an
> open transaction?

Try something like this:

SELECT * FROM pg_stat_activity
WHERE current_query = ' in transaction'
OR (query_start < NOW() - '10 minutes'::INTERVAL AND
current_query != '');

This gives you a list of open clients in transactions, or queries that have
been running for longer than 10 minutes.

--
Steve Simms 
http://www.deefs.net

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050104/70069058/attachment.html