Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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?

First transmission from NASA lander Spirit:


pgsql-novice by date

Next:From: Christian PöcherDate: 2004-03-17 09:55:24
Subject: Error in book
Previous:From: MohanDate: 2004-03-17 05:21:27
Subject: Storage system

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group