Postgres Pro
Downloads
Home   >   mailing lists

Re: Exclusive row locks not release - Mailing list pgsql-general

From Tom Lane
Subject Re: Exclusive row locks not release
Date
Msg-id 26344.1327038039@sss.pgh.pa.us
Whole thread Raw
In response to Exclusive row locks not release  (Mark van Leeuwen <markvl@internode.on.net>)
Responses Re: Exclusive row locks not release  (Mark van Leeuwen <markvl@internode.on.net>)
Numerous prepared transactions?  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Tree view 
Mark van Leeuwen <markvl@internode.on.net> 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_prepared_xacts.

            regards, tom lane

pgsql-general by date:

Previous
From: Mark van Leeuwen
Date:
Subject: Exclusive row locks not release
Next
From: Mark van Leeuwen
Date:
Subject: Re: Exclusive row locks not release