Re: PG-15.6: timeout parameters erroring out

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Mukesh Tanuku <mukesh(dot)postgres(at)gmail(dot)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=# 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
>