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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026