public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mukesh Tanuku <[email protected]>
To: Tom Lane <[email protected]>
Cc: rob stone <[email protected]>
Cc: [email protected]
Subject: Re: PG-15.6: timeout parameters erroring out
Date: Mon, 10 Feb 2025 21:38:45 +0530
Message-ID: <CAJzgB-GyuGBFMWRaX0Nb_AzLKSC_ZrggTh6yn+RpgF34OFQMxg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
	<[email protected]>
	<CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
	<CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
	<[email protected]>
	<CAJzgB-Fr+_4tEgHd9FPO_KbvnVSEMMiBjQxJ3TaJugS=hUgZCg@mail.gmail.com>
	<[email protected]>

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 PM Tom Lane <[email protected]> wrote:

> Mukesh Tanuku <[email protected]> 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=# set foo = 15min;
> ERROR:  trailing junk after numeric literal at or near "15min"
> LINE 1: set foo = 15min;
>                   ^
>
> In v14 that'd look like
>
> regression=# set foo = 15min;
> ERROR:  syntax error at or near "min"
> LINE 1: set foo = 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
>

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: PG-15.6: timeout parameters erroring out
  In-Reply-To: <CAJzgB-GyuGBFMWRaX0Nb_AzLKSC_ZrggTh6yn+RpgF34OFQMxg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox