From: Vik Fearing <vik@postgresfriends.org>
To: stepaunov@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
Date: Tue, 19 Oct 2021 10:20:45 +0200
Message-ID: <5b85039e-99da-5a8f-a42c-59e5660f60f2@postgresfriends.org> (raw)
In-Reply-To: <17237-c5fc7cb8ac3565ca@postgresql.org>
References: <17237-c5fc7cb8ac3565ca@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
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: vik@postgresfriends.org, stepaunov@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
In-Reply-To: <5b85039e-99da-5a8f-a42c-59e5660f60f2@postgresfriends.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