Re: Can pessimistic locking be emulated? - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Can pessimistic locking be emulated?
Date
Msg-id 1046368549.91396.74.camel@jester
Whole thread Raw
In response to Re: Can pessimistic locking be emulated?  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: Can pessimistic locking be emulated?
List pgsql-hackers
> In my case, being able to view outstanding row level locks would be
> enormously useful.  I'm assuming this is not possible for structural or

Agreed -- but they're stored on the row themselves.  You might be able
to write a function which executes dirty reads on the table and tells
you if the row is locked or not, but it's not going to be simple.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can pessimistic locking be emulated?
Next
From: Tom Lane
Date:
Subject: Re: analyze after a database restore?