| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | stepaunov(at)gmail(dot)com |
| Subject: | BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots. |
| Date: | 2021-10-19 07:41:49 |
| Message-ID: | 17237-c5fc7cb8ac3565ca@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17237
Logged by: Alexey Stepanov
Email address: stepaunov(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vik Fearing | 2021-10-19 08:20:45 | Re: BUG #17237: set_config: Custom parameter names must be two or more simple identifiers separated by dots. |
| Previous Message | Matthijs van der Vleuten | 2021-10-19 06:48:05 | Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable |