Re: Strange behavior: row won't delete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
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:17:09
Message-ID: 12861.1236100629@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

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