Bruce Momjian wrote:
>
> > > > > 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?
> > >
> > > It allows me to read uncommited records without blocking.
> >
> > I suppose it somehow lets you know whether the read was dirty or
> > clean...
>
> Not that I am aware of. Never heard that of Informix.
I also cheat. I use a 3 buffer approach, compare fields and see if a record
has
changed before I do an update.
--------
Regards
Theo