Lock won't release

Поиск
Список
Период
Сортировка
От Matt Friedman
Тема Lock won't release
Дата
Msg-id 007101c09130$c0a80b30$e8804318@mattq3h8budilr
обсуждение исходный текст
Ответы Re: Lock won't release  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have a lock on a table that won't release. I know this seems very unusual
but there appears to be a severe deadlock and pgsql has not release the
lock.

I've tried everything including recreating the db and trying to delete the
old one. psql wouldn't even let me delete the old db. It says that other
users are using the database. I'm assuming it's saying this because there's
a lock on the table.

Thanks for any help.

Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: matt@sprynewmedia.com
phone: 250 744 3655
fax: 250 370 0436




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

Предыдущее
От: Alfonso Peniche
Дата:
Сообщение: Re: Select in function?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Lock won't release