Re: SELECT FOR UPDATE NOWAIT

>
> Rod Taylor wrote:
> -- Start of PGP signed section.
> > On Fri, 2003-07-18 at 19:46, Paulo Scardine wrote:
> > > My boss is asking for something like Oracle's "SELECT FOR UPDATE
NOWAIT".
> > >
> > > Is there any such feature? If no, should I look forward into
implementing
> > > this? Any advice?
> >
> > Lookup STATEMENT_TIMEOUT and set it to a very short time.
>
> Some people have said they want to distinguish between a slow query
> (busy system) and waiting on a lock.  I can particulary see wanting to

> do a NOWAIT only on exclusive locks --- not sure how many really want
> that, though.
>
I think I'm a quite attentive to the SQL and HACKERS list, and I see
requests for a NOWAIT option at least once a month, and it's growing.
Regards, Christoph