Thread: Error code returned by lock_timeout
Hi,<br /><br /> I just realized that in the original incarnation of lock_timeout,<br /> I used <span class="Apple-style-span"style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant:normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect:none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size:medium; ">ERRCODE_LOCK_NOT_AVAILABLE (to be consistent with NOWAIT)<br /> but the patch that was accepted into9.3 contained </span><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style:normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans:2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing:0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect:none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size:medium; ">ERRCODE_QUERY_CANCELED</span><br /> which is the same as for statement_timeout.<br /><br /> Which wouldbe more correct?<br /><br /> Thanks in advance,<br /> Zoltán Böszörményi<br /><br /><pre class="moz-signature" cols="90">-- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: <a class="moz-txt-link-freetext" href="http://www.postgresql-support.de">http://www.postgresql-support.de</a> <aclass="moz-txt-link-freetext" href="http://www.postgresql.at/">http://www.postgresql.at/</a> </pre>
On Thu, Jun 27, 2013 at 2:22 PM, Boszormenyi Zoltan <zb@cybertec.at> wrote: > Hi, > > I just realized that in the original incarnation of lock_timeout, > I used ERRCODE_LOCK_NOT_AVAILABLE (to be consistent with NOWAIT) > but the patch that was accepted into 9.3 contained ERRCODE_QUERY_CANCELED > which is the same as for statement_timeout. > > Which would be more correct? ISTM that ERRCODE_LOCK_NOT_AVAILABLE is more suitable... Regards, -- Fujii Masao
2013-06-27 17:03 keltezéssel, Fujii Masao írta: > On Thu, Jun 27, 2013 at 2:22 PM, Boszormenyi Zoltan <zb@cybertec.at> wrote: >> Hi, >> >> I just realized that in the original incarnation of lock_timeout, >> I used ERRCODE_LOCK_NOT_AVAILABLE (to be consistent with NOWAIT) >> but the patch that was accepted into 9.3 contained ERRCODE_QUERY_CANCELED >> which is the same as for statement_timeout. >> >> Which would be more correct? > ISTM that ERRCODE_LOCK_NOT_AVAILABLE is more suitable... I think, too. Can someone commit this one-liner to master and 9.3? Best regards, Zoltán Bsöszörményi -- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de http://www.postgresql.at/