On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula <phoenix.ki...@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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
