MIME-Version: 1.0
From: Manav Kumar <mkumar@yugabyte.com>
Date: Fri, 20 Jun 2025 17:49:34 +0530
Message-ID: 
 <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com>
Subject: Unable to set guc via setProperty
To: pgsql-jdbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000bc4eaa0637ffe023"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPhCW%2B9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL%2BCHX7A%40mail.gmail.com>
Precedence: bulk

--000000000000bc4eaa0637ffe023
Content-Type: text/plain; charset="UTF-8"

Hi Team,
I've a doubt regarding passing guc variables in start up packet as key
value pairs instead of in options.

I'm unable to set jdbc:postgresql://10.150.3.175:6433/postgres?&geqo=off
m geqo to 'off'. I don't want to use "options" rather pass directly key
value pairs similar to what JDBC driver internally does.

Neither setProperty("geqo", "off") works in this case.
Can someone let me know why I can't do it?

I learnt or from code, it's seen the key value pairs has higher precedence
or override the guc values passed via cmdline option("options") field when
both passed in start up packet.
That's why with JDBC, even i try to set "options - DateStyle to
'Postgres,DM'Y'" we are unable to change value as DateStyle is also passed
as key value by driver with 'ISO' which has higher precedence.
Thanks
Manav

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

<div dir=3D"ltr">Hi Team,<div>I&#39;ve a doubt regarding passing guc variab=
les=C2=A0in start up packet as key value pairs instead of in options.=C2=A0=
</div><div><br></div><div>I&#39;m unable=C2=A0to set=C2=A0<span style=3D"co=
lor:rgb(206,145,120);background-color:rgb(30,30,30);font-family:Menlo,Monac=
o,&quot;Courier New&quot;,monospace;font-size:12px;white-space:pre">jdbc:po=
stgresql://<a href=3D"http://10.150.3.175:6433/postgres?&amp;geqo=3Doff">10=
.150.3.175:6433/postgres?&amp;geqo=3Doff</a> </span></div><div>m geqo to &#=
39;off&#39;. I don&#39;t want to use &quot;options&quot; rather pass direct=
ly key value pairs similar to what JDBC driver internally does.=C2=A0</div>=
<div><br></div><div>Neither=C2=A0setProperty(&quot;geqo&quot;, &quot;off&qu=
ot;) works in this case.</div><div>Can someone let me know why I can&#39;t =
do it?=C2=A0</div><div><br></div><div>I learnt or from code, it&#39;s seen =
the key value pairs has higher=C2=A0precedence or override the guc values p=
assed via cmdline option(&quot;options&quot;) field when both passed in sta=
rt up packet.=C2=A0</div><div>That&#39;s why with JDBC, even i try to set &=
quot;options - DateStyle to &#39;Postgres,DM&#39;Y&#39;&quot; we are unable=
 to change value as DateStyle is also passed as key value by driver with &#=
39;ISO&#39; which has higher precedence.=C2=A0=C2=A0</div><div>Thanks</div>=
<div>Manav</div></div>

--000000000000bc4eaa0637ffe023--