Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange behavior: row won't delete - Mailing list pgsql-general

From Tom Lane
Subject Re: Strange behavior: row won't delete
Date
Msg-id 12861.1236100629@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange behavior: row won't delete  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Responses Re: Strange behavior: row won't delete  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
Tree view 
Phoenix Kiula <phoenix.kiula@gmail.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

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Strange behavior: row won't delete
Next
From: Phoenix Kiula
Date:
Subject: How to delete all locks? Re: Strange behavior: row won't delete