Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error code returned by lock_timeout

Error code returned by lock_timeout

From
Boszormenyi Zoltan
Date:
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>

Re: Error code returned by lock_timeout

From
Fujii Masao
Date:
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

Re: Error code returned by lock_timeout

From
Boszormenyi Zoltan
Date:
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/
Attachment