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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073