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