Re: How to unlock a row - Mailing list pgsql-general

From Jerry Sievers
Subject Re: How to unlock a row
Date
Msg-id m33b6y8vp6.fsf@mama.jerrysievers.com
Whole thread Raw
In response to How to unlock a row  ("vinjvinj" <vinjvinj@gmail.com>)
List pgsql-general
"vinjvinj" <vinjvinj@gmail.com> 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

pgsql-general by date:

Previous
From: "Wenjian Yang"
Date:
Subject: Re: LDAP configuration problem
Next
From: "Joshua D. Drake"
Date:
Subject: Re: LDAP configuration problem