Re: Strange behavior: row won't delete

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange behavior: row won't delete
Date: 2009-03-03 16:33:08
Message-ID: e373d31e0903030833k4df71331w6fdc0aba5582cc18@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Although when I try this:

select pg_class.relname,pg_locks.* from pg_class,pg_locks where
pg_class.relfilenode=pg_locks.relation;

There are many rows!

How can I get rid of these open locks?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-03-03 16:36:32 Re: Strange behavior: row won't delete
Previous Message Phoenix Kiula 2009-03-03 16:27:25 Re: Strange behavior: row won't delete