pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
2+ messages / 2 participants
[nested] [flat]
* BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
@ 2021-10-19 07:41 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-10-19 07:41 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: stepaunov@gmail.com
The following bug has been logged on the website:
Bug reference: 17237
Logged by: Alexey Stepanov
Email address: stepaunov@gmail.com
PostgreSQL version: 14.0
Operating system: Debian 8.3.0-6, 64-bit
Description:
Our app uses guids as first part of set_config parameter name.
On PostgreSQL 14.0 this script results in an error:
SELECT set_config('182e33e7-12ff-4c4f-bc6e-0822e72fa7a4.param1'
,'test',true);
Exception:
[42602] ERROR: invalid configuration parameter name
"182e33e7-12ff-4c4f-bc6e-0822e72fa7a4.param1"
Custom parameter names must be two or more simple identifiers separated by
dots.
On previous versions, for example, on PostgreSQL 12.1 on
x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0
20170516, 64-bit,
the same script executed succesfully and works properly.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
@ 2021-10-19 08:20 Vik Fearing <vik@postgresfriends.org>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Vik Fearing @ 2021-10-19 08:20 UTC (permalink / raw)
To: stepaunov@gmail.com; pgsql-bugs@lists.postgresql.org
On 10/19/21 9:41 AM, PG Bug reporting form wrote:
>
> Our app uses guids as first part of set_config parameter name.
>
> On PostgreSQL 14.0 this script results in an error:
> SELECT set_config('182e33e7-12ff-4c4f-bc6e-0822e72fa7a4.param1'
> ,'test',true);
>
> Exception:
> [42602] ERROR: invalid configuration parameter name
> "182e33e7-12ff-4c4f-bc6e-0822e72fa7a4.param1"
> Custom parameter names must be two or more simple identifiers separated by
> dots.
This is not a bug but a deliberate change. It is mentioned in the
release notes (https://www.postgresql.org/docs/14/release-14.html) as a
backwards-incompatible change.
--
Vik Fearing
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-19 08:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-19 07:41 BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots. PG Bug reporting form <noreply@postgresql.org>
2021-10-19 08:20 ` Vik Fearing <vik@postgresfriends.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox