Deadlock removal

[Albrecht Stephen]

Hi,
I have somehow managed to lock a row in one of my database tables, and I am now unable to unlock that row.

I have tried using the ROLLBACK command, but get a notice: NO TRANSACTION IN PROGRESS. However, when I try to update or delete the record, the query never executes, and I have to cancel it manually, at which point I get the error: QUERY CANCEL REQUESTED WHILE WAITING LOCK.

Anybody know how I can simply get rid of this lock?

Thanks,
Stephen.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Peter Eisentraut]

Albrecht Stephen (LWE) wrote:

Anybody know how I can simply get rid of this lock?

A lock can only be held by a running transaction. Therefore, to release
the lock for sure, terminate all other running transactions.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly