Removing "lost" locks

From: Christian Pöcher <Poecher(at)gmx(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Removing "lost" locks
Date: 2004-03-17 09:50:30
Message-ID: 000901c40c05$4c6c1ce0$110acad4@dose
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!"

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Christian Pöcher 2004-03-17 09:55:24 Error in book
Previous Message Mohan 2004-03-17 05:21:27 Storage system