Deadlock removal

Поиск
Список
Период
Сортировка
От Albrecht Stephen (LWE)
Тема Deadlock removal
Дата
Msg-id BFA3D3FAFA22D311BE2D0000D11D41A605977CF4@HERMES
обсуждение исходный текст
Ответы Re: Deadlock removal  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
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
deletethe record, the query never executes, and I have to cancel it manually, at which point I get the error: QUERY
CANCELREQUESTED WHILE WAITING LOCK. 

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

Thanks,
Stephen.

В списке pgsql-general по дате отправления:

Предыдущее
От: "michael.wimmer"
Дата:
Сообщение: Re: unicode and varchar
Следующее
От: "Henriksen, Jonas F"
Дата:
Сообщение: how to use geometric shapes?