(Excuse my english, my native language is portuguese) > 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
Yes. I have done a little google about "pgsql select for update nowait" and find lot of people looking for this feature. If there is a lock and NOWAIT is specified, then raise error instead of waiting for the lock to release. We have some long distance connections that get very busy sometimes and is hard to distinguish between network problems and locked rows. Do you see it as something hard to implement? Any advice? Is it just to add an "opt_nowait" to the "FOR UPDATE" clause in the parser and checking for this option when trying to get the lock later? TIA, -- Paulo Scardine ----- Original Message ----- From: "Christoph Haller" <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 4:35 AM Subject: Re: [HACKERS] SELECT FOR UPDATE NOWAIT ... > > > 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. > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.490 / Virus Database: 289 - Release Date: 16/6/2003 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
