Removing "lost" locks - Mailing list pgsql-novice

From Christian Pöcher
Subject Removing "lost" locks
Date
Msg-id 000901c40c05$4c6c1ce0$110acad4@dose
Whole thread Raw
List 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 by date:

Previous
From: Mohan
Date:
Subject: Storage system
Next
From: Christian Pöcher
Date:
Subject: Error in book