Re: [GENERAL] Exclusive row locks not release

2012-01-19 Thread Mark van Leeuwen
On 20/01/2012 4:40 PM, Tom Lane wrote: Mark van Leeuwen writes: I have a case where exclusive row locks have been placed on a table and I don't what process has the locks or how they might be released. The locks are still there even after I have restarted the database. Uncommitted prepared tra

Re: [GENERAL] Exclusive row locks not release

2012-01-19 Thread Tom Lane
Mark van Leeuwen writes: > I have a case where exclusive row locks have been placed on a table and > I don't what process has the locks or how they might be released. > The locks are still there even after I have restarted the database. Uncommitted prepared transaction, perhaps? Look into pg_