From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mukesh Tanuku <mukesh.postgres@gmail.com>
cc: rob stone <floriparob@tpg.com.au>, pgsql-general@lists.postgresql.org
Subject: Re: PG-15.6: timeout parameters erroring out
In-reply-to: <CAJzgB-Fr+_4tEgHd9FPO_KbvnVSEMMiBjQxJ3TaJugS=hUgZCg@mail.gmail.com>
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>
Comments: In-reply-to Mukesh Tanuku <mukesh.postgres@gmail.com>
	message dated "Mon, 10 Feb 2025 19:04:12 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2196051.1739203257.1@sss.pgh.pa.us>
Date: Mon, 10 Feb 2025 11:00:57 -0500
Message-ID: <2196052.1739203257@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2196052.1739203257%40sss.pgh.pa.us>
Precedence: bulk

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