MIME-Version: 1.0
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
 <2106557.1739163733@sss.pgh.pa.us> <CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
 <CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
 <788aca1329878b3fbc93da929bd54b758ec5e4b4.camel@tpg.com.au>
 <CAJzgB-Fr+_4tEgHd9FPO_KbvnVSEMMiBjQxJ3TaJugS=hUgZCg@mail.gmail.com> <2196052.1739203257@sss.pgh.pa.us>
In-Reply-To: <2196052.1739203257@sss.pgh.pa.us>
From: Mukesh Tanuku <mukesh.postgres@gmail.com>
Date: Mon, 10 Feb 2025 21:38:45 +0530
Message-ID: <CAJzgB-GyuGBFMWRaX0Nb_AzLKSC_ZrggTh6yn+RpgF34OFQMxg@mail.gmail.com>
Subject: Re: PG-15.6: timeout parameters erroring out
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: rob stone <floriparob@tpg.com.au>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e317e4062dcbec9f"
Archived-At: <https://www.postgresql.org/message-id/CAJzgB-GyuGBFMWRaX0Nb_AzLKSC_ZrggTh6yn%2BRpgF34OFQMxg%40mail.gmail.com>
Precedence: bulk

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

Thanks for all of you for responding and clarifying things. Really
appreciate it.

We finally confirmed that it is a SET command issue where the AWX
application is firing the query without quotes and it's a known bug from
their end.

Thank you once again.
Regards
Mukesh Tanuku

On Mon, Feb 10, 2025 at 9:30=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Mukesh Tanuku <mukesh.postgres@gmail.com> writes:
> > Is this issue specifically reported in only the PG 15 version? more
> syntax
> > sensitivity.
>
> PG 15 and up report the syntax error differently.
>
> regression=3D# set foo =3D 15min;
> ERROR:  trailing junk after numeric literal at or near "15min"
> LINE 1: set foo =3D 15min;
>                   ^
>
> In v14 that'd look like
>
> regression=3D# set foo =3D 15min;
> ERROR:  syntax error at or near "min"
> LINE 1: set foo =3D 15min;
>                     ^
>
> There are variants of this (lack of space between a number and an
> identifier) that will be rejected by 15+ although older versions
> accepted them.  But in a SET command I think no version will take it.
>
>                         regards, tom lane
>

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

<div dir=3D"ltr">Thanks for all of you for responding and clarifying things=
. Really appreciate it.<div><br></div><div>We finally confirmed=C2=A0that i=
t is a SET command issue where the AWX application is firing the query with=
out quotes and it&#39;s a known bug from their=C2=A0end.=C2=A0</div><div><b=
r></div><div>Thank you once again.</div><div>Regards</div><div>Mukesh Tanuk=
u</div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">On Mon, Feb 10, 2025 at 9:30=E2=80=AFPM Tom L=
ane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Mukesh Tanuku=
 &lt;<a href=3D"mailto:mukesh.postgres@gmail.com" target=3D"_blank">mukesh.=
postgres@gmail.com</a>&gt; writes:<br>
&gt; Is this issue specifically reported in only the PG 15 version? more sy=
ntax<br>
&gt; sensitivity.<br>
<br>
PG 15 and up report the syntax error differently.<br>
<br>
regression=3D# set foo =3D 15min;<br>
ERROR:=C2=A0 trailing junk after numeric literal at or near &quot;15min&quo=
t;<br>
LINE 1: set foo =3D 15min;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ^<br>
<br>
In v14 that&#39;d look like<br>
<br>
regression=3D# set foo =3D 15min;<br>
ERROR:=C2=A0 syntax error at or near &quot;min&quot;<br>
LINE 1: set foo =3D 15min;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ^<br>
<br>
There are variants of this (lack of space between a number and an<br>
identifier) that will be rejected by 15+ although older versions<br>
accepted them.=C2=A0 But in a SET command I think no version will take it.<=
br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--000000000000e317e4062dcbec9f--