Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckMg-0007T5-63 for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Oct 2021 08:20:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mckMe-0002mX-Ss for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Oct 2021 08:20:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckMe-0002mN-LQ for pgsql-bugs@lists.postgresql.org; Tue, 19 Oct 2021 08:20:52 +0000 Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckMb-0005T1-Jr for pgsql-bugs@lists.postgresql.org; Tue, 19 Oct 2021 08:20:51 +0000 Received: (Authenticated sender: vik@postgresfriends.org) by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id D3C0F6000A; Tue, 19 Oct 2021 08:20:46 +0000 (UTC) Subject: Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots. To: stepaunov@gmail.com, pgsql-bugs@lists.postgresql.org References: <17237-c5fc7cb8ac3565ca@postgresql.org> From: Vik Fearing Message-ID: <5b85039e-99da-5a8f-a42c-59e5660f60f2@postgresfriends.org> Date: Tue, 19 Oct 2021 10:20:45 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: <17237-c5fc7cb8ac3565ca@postgresql.org> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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