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@xxxxxxxxxxxxx> wrote:
Mukesh Tanuku <mukesh.postgres@xxxxxxxxx> 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
