How to delete all locks? Re: Strange behavior: row won't delete

On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> I guess my question is, how should I remove all pending locks on a
> table so that I can get on with the rest of the stuff?
>
> I mean, even if I can now find an offending RULE on the table, I
> cannot replace or remove it. '



Any ideas? I think I have identified the offending RULE that was newly
created on the table. It may have missed the WHERE condition.

But even if CREATE OR REPLACE this rule, the command doesn't go
through. So I'm stuck in a vicious loop.

How can I get rid of all open locks? When I go through pg_locks there
are about 1041 of them right now. I am looking for a mechanism of
deleting them all (can I just delete all rows in pg_locks?) instead of
manually going through 1041 on a live database.

Thanks!