Обсуждение: Removing "lost" locks

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!"

Sorry for bothering you,

I have the problem resolved now. I had a "ghost" instance of my application
running. After killing it, pgsql removed all locks and everything works as
expected.

chris