BUG #19538: ALTER SYSTEM adds extra quotes

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: fotonszekta(at)gmail(dot)com
Subject: BUG #19538: ALTER SYSTEM adds extra quotes
Date: 2026-06-29 08:08:57
Message-ID: 19538-79b6b974a7b189b9@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 19538
Logged by: Gábor Szabó
Email address: fotonszekta(at)gmail(dot)com
PostgreSQL version: 14.23
Operating system: Ubuntu 24.04.4
Description:

The following command adds extra quotes to postgresql.auto.conf:
ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements, auth_delay,
auto_explain, pg_prewarm';
The result entry in postgresql.auto.conf is:
shared_preload_libraries = '"pg_stat_statements, auth_delay, auto_explain,
pg_prewarm"'
As a result, PostgreSQL tries to load the entire string as a single library
name and reports the following error in /var/log/postgresql:
FATAL: could not access file "pg_stat_statements, auth_delay, auto_explain,
pg_prewarm": Nincs ilyen fájl vagy könyvtár

("Nincs ilyen fájl vagy könyvtár" is the Hungarian translation of "No such
file or directory", because the server is running with the hu_HU.UTF-8
locale)

When I run ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements';
It works correctly and the resulting entry is:
shared_preload_libraries = 'pg_stat_statements'

However, when the value contains commas, the extra double quotes appear
around the entire string.
I also tried using double quotes in the ALTER SYSTEM command, but the result
was the same.

I reproduced the same behavior on my development system running PostgreSQL
18.4 on Windows.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bill Kim 2026-06-29 12:04:52 Re: BUG #19524: NaN handling in btree_gist's float4/float8 opclasses
Previous Message Tender Wang 2026-06-29 01:53:11 Re: BUG #19534: Qual pushdown across a window subquery is unsafe with nondeterministic partition collations