Re: Determining if a record is locked

Yes, you can do a SELECT ... FOR UPDATE NOWAIT on the row(s) in question. If the SELECT can't obtain row locks on all of the rows, it will return immediately and there is some way to tell if it worked, although I can't find it at the moment.

Nuno Guerreiro wrote:
>
> On Wed, 04 Mar 1998 15:18:59 -0700, Kent Anderson <anderske_at_agcs.com>
> wrote:
>
> >Is there a way to tell if a record is locked without
> >actually blocking on it?
> >
> >My situation is that we have two processes acting
> >on the same tables in a database. If the first process
> >updates a record, then the second process's update on that
> >record will block until the first process ends its
> >transaction.
> >
> >Is there any way for the second process to determine
> >if the record is locked so it can put it off until
> >later?
> >
> >--
> >+=================================================================+
> >| Kent Anderson Phone: (602) 581-4332 |
> >| Engineer E-mail: anderske_at_agcs.com |
> >| AG Communications Systems |
> >| Phoenix, Arizona "Expand the power of you network" |

 +-----------------------------------------------------------------+


> >|           Visit us on the web at http://www.agcs.com            |

> >+=================================================================+