Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19538: ALTER SYSTEM adds extra quotes
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: fotonszekta@gmail.com
Reply-To: fotonszekta@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Mon, 29 Jun 2026 08:08:57 +0000
Message-ID: <19538-79b6b974a7b189b9@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19538-79b6b974a7b189b9%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19538
Logged by:          G=C3=A1bor Szab=C3=B3
Email address:      fotonszekta@gmail.com
PostgreSQL version: 14.23
Operating system:   Ubuntu 24.04.4
Description:       =20

The following command adds extra quotes to postgresql.auto.conf:
ALTER SYSTEM SET shared_preload_libraries =3D 'pg_stat_statements, auth_del=
ay,
auto_explain, pg_prewarm';
The result entry in postgresql.auto.conf is:
shared_preload_libraries =3D '"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=C3=A1jl vagy k=C3=B6nyvt=C3=A1r

("Nincs ilyen f=C3=A1jl vagy k=C3=B6nyvt=C3=A1r" is the Hungarian translati=
on 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 =3D 'pg_stat_statement=
s';
It works correctly and the resulting entry is:
shared_preload_libraries =3D '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.