"Booth, Robert" <Robert_Booth(at)intuit(dot)com> writes:
> I have a strange problem. I have lost the ability to query a table. Every
> time I try to query it the system just hangs.
Please define "hang" --- is the whole system locked up, or do you just
not get a response to that query? What do you do to recover?
My bet is that there's an open transaction somewhere holding an
exclusive lock on the table ...
regards, tom lane