>
> > 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,
Pennsylvania19026