Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
Дата
Msg-id 5b85039e-99da-5a8f-a42c-59e5660f60f2@postgresfriends.org
обсуждение исходный текст
Ответ на BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
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



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots.
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: BUG #17229: Segmentation Fault after upgrading to version 13