Re: [HACKERS] please? (non blocking lock)

I don't know of any SQL databases that allow non-blocking lock requests.

Informix has all kinds of non blocking locks:
return "record locked" at once
return "record locked" after a specified timeout
wait for the lock indefinitely

To supply this behavior it has the following statements:
set lock mode to not wait; -- return immediately with error
-- if record already locked
set lock mode to wait 10; -- wait at max 10 seconds
set lock mode to wait; -- wait indefinitely

Dirty read isolation has actually nothing to do with the wanted feature.

Oh, that's nice. I never looked at those commands before.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026