Re: PG-15.6: timeout parameters erroring out - Mailing list pgsql-general

From Mukesh Tanuku
Subject Re: PG-15.6: timeout parameters erroring out
Date
Msg-id CAJzgB-GyuGBFMWRaX0Nb_AzLKSC_ZrggTh6yn+RpgF34OFQMxg@mail.gmail.com
Whole thread Raw
In response to Re: PG-15.6: timeout parameters erroring out  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@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=# 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG-15.6: timeout parameters erroring out
Next
From: Josef Šimánek
Date:
Subject: Any plan for minor release?