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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
