Zeugswetter Andreas SB SD wrote: > > > > The question is whether we should have a GUC variable to control no > > > waiting on locks or add NO WAIT to specific SQL commands. > > > > > > Does anyone want to vote _against_ the GUC idea for nowait locking. (We > > > already have two voting for such a variable.) > > > > I vote against. We got bit by both the regex and the autocommit GUC vars > > and this is setting up to cause a similar headache with old code on new > > platforms. > > I vote for the GUC. Imho it is not comparable to the "autocommit" case, > since it does not change the way your appl needs to react (appl needs to > react to deadlock already). > > I personally think a wait period in seconds would be more useful. > Milli second timeouts tend to be misused with way too low values > in this case, imho.
I understand, but GUC lost the vote. I have updated the TODO list to indicate this. Tatsuo posted a patch to add NO WAIT to the LOCK command, so we will see if we can get that into CVS. -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
