Re: Exclusive row locks not release

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