Re: Strange behavior: row won't delete

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange behavior: row won't delete
Date: 2009-03-03 17:23:26
Message-ID: e373d31e0903030923p590c8fd1kd49a7bd5631ad018@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 4, 2009 at 1:17 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> writes:
>> How can I get rid of these open locks?
>
> Close the transactions that are holding them.  Look into
> pg_stat_activity and pg_prepared_xacts.

Thanks for this. But can I simply delete all the pg_locks table? Or
delete all rows in pg_stat_activity? In my case the _xacts table is
empty. Ideally I don't want to lose pg_stat_activity. I just want to
change a RULE on a table. Is there any place I can do that?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2009-03-03 17:25:32 Re: Strange behavior: row won't delete
Previous Message Phoenix Kiula 2009-03-03 17:18:46 How to delete all locks? Re: Strange behavior: row won't delete