MIME-Version: 1.0
References: <CAKoxK+7UEeJhk_hbv1_3KwN1SD8O6ByU-cCr55mFDkErRxZcow@mail.gmail.com>
In-Reply-To: <CAKoxK+7UEeJhk_hbv1_3KwN1SD8O6ByU-cCr55mFDkErRxZcow@mail.gmail.com>
From: Victor Yegorov <vyegorov@gmail.com>
Date: Wed, 30 Apr 2025 15:19:01 +0300
Message-ID: <CAGnEbogyL+2w59QDQg9dbFcFvmbfYp2jWwOjW9FTtuS_z9Oivw@mail.gmail.com>
Subject: Re: alter system appending to a value
To: Luca Ferrari <fluca1978@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c5f3e20633fdecfa"
Archived-At: <https://www.postgresql.org/message-id/CAGnEbogyL%2B2w59QDQg9dbFcFvmbfYp2jWwOjW9FTtuS_z9Oivw%40mail.gmail.com>
Precedence: bulk

--000000000000c5f3e20633fdecfa
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=D1=81=D1=80, 30 =D0=B0=D0=BF=D1=80. 2025=E2=80=AF=D0=B3. =D0=B2 14:15, Luc=
a Ferrari <fluca1978@gmail.com>:

> as trivial as it sounds, is there a smart way to use ALTER SYSTEM to
> append to a value?
> Something like: ALTER SYSTEM shared_preloaded_libraries =3D
> current_setting( 'shared_preloaded_libraries' ) || ',foo';
>

I would do smth like:
SELECT format( 'ALTER SYSTEM SET shared_preload_libraries =3D %L;', setting=
 )
  FROM pg_settings WHERE name =3D 'shared_preload_libraries' \gexec

Of course, you should add new value to the existing setting, making sure
there are no duplicates and the format is correct.

--=20
Victor Yegorov

--000000000000c5f3e20633fdecfa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">=D1=81=D1=80, 30 =D0=B0=D0=BF=D1=80. 2025=
=E2=80=AF=D0=B3. =D0=B2 14:15, Luca Ferrari &lt;<a href=3D"mailto:fluca1978=
@gmail.com">fluca1978@gmail.com</a>&gt;:</div><div class=3D"gmail_quote gma=
il_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">as tr=
ivial as it sounds, is there a smart way to use ALTER SYSTEM to<br>
append to a value?<br>
Something like: ALTER SYSTEM shared_preloaded_libraries =3D<br>
current_setting( &#39;shared_preloaded_libraries&#39; ) || &#39;,foo&#39;;<=
br></blockquote><div><br>I would do smth like:<br>SELECT format( &#39;ALTER=
 SYSTEM SET shared_preload_libraries =3D %L;&#39;, setting )<br>=C2=A0 FROM=
 pg_settings WHERE name =3D &#39;shared_preload_libraries&#39; \gexec<br><b=
r>Of course, you should add new value to the existing setting, making sure =
there are no duplicates and the format is correct.</div></div><div><br></di=
v><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cla=
ss=3D"gmail_signature"><div dir=3D"ltr"><div>Victor Yegorov</div></div></di=
v></div>

--000000000000c5f3e20633fdecfa--