Bruce Momjian <maillist@candle.pha.pa.us>
>
> > Bruce Momjian wrote:
> > >
> > > I don't know of any SQL databases that allow non-blocking lock requests.
> > >
> >
> > Oracle OCI has oopt() and Informix Online has dirty read that do the trick for
> > me.
> > --------
>
> Please give me more information. How does dirty read fix the problem?
>
This all sounds like the Oracle NOWAIT option.
Session1.
SQL> select value from sys_param where name = 'ASG_SYSTEM_DESC' for update;
VALUE ------------------------------ tpwmamda
SQL>
Session2.
SQL> select value from sys_param where name = 'ASG_SYSTEM_DESC' for update nowait; ERROR: ORA-00054: resource busy and
acquirewith NOWAIT specified
no rows selected
SQL>
No idea how to impliment it though!!