Removing "lost" locks

Поиск
Список
Период
Сортировка
От Christian Pöcher
Тема Removing "lost" locks
Дата
Msg-id 000901c40c05$4c6c1ce0$110acad4@dose
обсуждение исходный текст
Список pgsql-novice
Hi there,

I'm using pgsql with the Hibernate O/R-mapping package. While experimenting
with it I somehow put locks on my testdatabase, so I cannot delete the
tables anymore. I guess I left transactions open, but that has to be
analysed. Anyway, now I have to get rid of the locks. I tried to delete from
pg_locks, but as it is a view I cannot delete rows from it.

Any suggestions?

chris
--
First transmission from NASA lander Spirit:
"Uuuulaaa!"


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

Предыдущее
От: Mohan
Дата:
Сообщение: Storage system
Следующее
От: Christian Pöcher
Дата:
Сообщение: Error in book