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

From Tom Lane
Subject Re: PG-15.6: timeout parameters erroring out
Date
Msg-id 2196052.1739203257@sss.pgh.pa.us
Whole thread Raw
In response to PG-15.6: timeout parameters erroring out  (Mukesh Tanuku <mukesh.postgres@gmail.com>)
Responses Re: PG-15.6: timeout parameters erroring out
List pgsql-general
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: Passwordcheck Extension Not Installing
Next
From: Mukesh Tanuku
Date:
Subject: Re: PG-15.6: timeout parameters erroring out