On 20/01/2012 4:40 PM, Tom Lane wrote:
Mark van Leeuwen<markvl@xxxxxxxxxxxxxxxx> 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
Yes, that was it. Don't have much experience with Postgresql - had
expected all locks would have been released by stopping the database.
I used ROLLBACK PREPARED transaction_id to remove the locks.
Thanks for your help,
Mark
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
