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 oncereturn "record locked" after a specified timeoutwait 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 lockedset lock mode to wait 10;  	-- wait at max 10 secondsset lock mode to wait;		-- wait indefinitely

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

Andreas