Lock won't release

From: "Matt Friedman" <matt(at)daart(dot)ca>
To: "PgSql General List" <pgsql-general(at)postgresql(dot)org>
Subject: Lock won't release
Date: 2001-02-07 18:06:53
Message-ID: 007101c09130$c0a80b30$e8804318@mattq3h8budilr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a lock on a table that won't release. I know this seems very unusual
but there appears to be a severe deadlock and pgsql has not release the
lock.

I've tried everything including recreating the db and trying to delete the
old one. psql wouldn't even let me delete the old db. It says that other
users are using the database. I'm assuming it's saying this because there's
a lock on the table.

Thanks for any help.

Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: matt(at)sprynewmedia(dot)com
phone: 250 744 3655
fax: 250 370 0436

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-07 18:44:23 Re: Lock won't release
Previous Message Alfonso Peniche 2001-02-07 17:45:52 Re: Select in function?