From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: stepaunov@gmail.com
Subject: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
Date: Tue, 19 Oct 2021 07:41:49 +0000
Message-ID: <17237-c5fc7cb8ac3565ca@postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, stepaunov@gmail.com
Subject: Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
In-Reply-To: <17237-c5fc7cb8ac3565ca@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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