MIME-Version: 1.0
References: <SL2P216MB1380EF37EA7D6193C83622C6F5F22@SL2P216MB1380.KORP216.PROD.OUTLOOK.COM>
In-Reply-To: <SL2P216MB1380EF37EA7D6193C83622C6F5F22@SL2P216MB1380.KORP216.PROD.OUTLOOK.COM>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 29 May 2024 09:19:10 -0400
Message-ID: <CAKAnmmKmwKhPPrqpZMp65mr4vT_CwQQHQB4bvAzXdbuKq_DwzA@mail.gmail.com>
Subject: Re: Timeout gets unset on a syntax error.
To: "ISHAN CHHANGANI ." <f20200230@hyderabad.bits-pilani.ac.in>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e947210619979a05"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKmwKhPPrqpZMp65mr4vT_CwQQHQB4bvAzXdbuKq_DwzA%40mail.gmail.com>
Precedence: bulk

--000000000000e947210619979a05
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, May 29, 2024 at 6:29=E2=80=AFAM ISHAN CHHANGANI . <
f20200230@hyderabad.bits-pilani.ac.in> wrote:

> Is there some code within Postgres that resets/removes the signals in cas=
e
> a query hits any error?
>

See the comment and call to disable_all_timeouts() in postgres.c, part of
the cleanup-after-exception efforts:

https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3Dsrc/back=
end/tcop/postgres.c#l4356


Cheers,
Greg

--000000000000e947210619979a05
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, May 29, 2024 at 6:29=E2=80=AFAM I=
SHAN CHHANGANI . &lt;<a href=3D"mailto:f20200230@hyderabad.bits-pilani.ac.i=
n">f20200230@hyderabad.bits-pilani.ac.in</a>&gt; wrote:<br></div><div class=
=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div cla=
ss=3D"msg-716374812308427147"><div lang=3D"EN-IN" style=3D"overflow-wrap: b=
reak-word;"><div class=3D"m_-716374812308427147WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US">Is there some code within Postg=
res that resets/removes the signals in case a query hits any error?</span><=
/p></div></div></div></blockquote><div><br></div><div>See the comment and c=
all to disable_all_timeouts() in postgres.c, part of the cleanup-after-exce=
ption efforts:</div><div><br></div><div><a href=3D"https://git.postgresql.o=
rg/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3Dsrc/backend/tcop/postgres.c#l435=
6">https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3Dsrc/b=
ackend/tcop/postgres.c#l4356</a></div><div><br></div><div><br></div><div>Ch=
eers,</div><div>Greg</div><div><br></div></div></div>

--000000000000e947210619979a05--