Re: Can pessimistic locking be emulated?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Can pessimistic locking be emulated?
Date: 2003-02-27 17:55:49
Message-ID: 1046368549.91396.74.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rbt(dot)ca>

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2003-02-27 18:01:09 Re: analyze after a database restore?
Previous Message Tom Lane 2003-02-27 17:55:42 Re: analyze after a database restore?