| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mukesh Tanuku <mukesh(dot)postgres(at)gmail(dot)com> |
| Cc: | rob stone <floriparob(at)tpg(dot)com(dot)au>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PG-15.6: timeout parameters erroring out |
| Date: | 2025-02-10 16:00:57 |
| Message-ID: | 2196052.1739203257@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mukesh Tanuku | 2025-02-10 16:08:45 | Re: PG-15.6: timeout parameters erroring out |
| Previous Message | Tom Lane | 2025-02-10 15:53:48 | Re: Passwordcheck Extension Not Installing |