How to unlock a row

From: "vinjvinj" <vinjvinj(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to unlock a row
Date: 2006-12-29 14:29:00
Message-ID: 1167402540.818296.159620@k21g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vinjvinj 2006-12-29 14:33:08 Re: How to unlock a row
Previous Message Andrus 2006-12-29 11:04:08 Re: Why ContinueUpdateOnError is not implemented in npgsql