"vinjvinj" <[EMAIL PROTECTED]> writes:
> One of my updates is hanging on a postgres table. I'm guessing if the
> table or row is locked.
>
> Questions:
>
> 1. What table can I select from to find the lock?
> 2. How do I clear the lock?
1pg_locks view, perhaps joined with pg_class and pg_stat_ac
> 1. What table can I select from to find the lock?
pg_locks shows no rows returned. But the update still hangs.
VJ
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
One of my updates is hanging on a postgres table. I'm guessing if the
table or row is locked.
Questions:
1. What table can I select from to find the lock?
2. How do I clear the lock?
Thanks for your help
VJ
---(end of broadcast)---
TIP 5: don't
