Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group