"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_activity
2. Commit all open regular or 2-phase transactions.
> Thanks for your help
>
> VJ
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) Production Database Administrator
305 321-1144 (mobil WWW E-Commerce Consultant
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
