MIME-Version: 1.0
In-Reply-To: 
 <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com>
References: 
 <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 20 Jun 2025 07:22:51 -0700
Message-ID: 
 <CAKFQuwaLd4tOYxE-Hw8CCWw2KZN_GooAmg6uHcOFF+et6hDNxw@mail.gmail.com>
Subject: Re: Unable to set guc via setProperty
To: Manav Kumar <mkumar@yugabyte.com>
Cc: "pgsql-jdbc@lists.postgresql.org" <pgsql-jdbc@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f4bc5706380198f9"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwaLd4tOYxE-Hw8CCWw2KZN_GooAmg6uHcOFF%2Bet6hDNxw%40mail.gmail.com>
Precedence: bulk

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

On Friday, June 20, 2025, Manav Kumar <mkumar@yugabyte.com> wrote:

> 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=3Dof=
f
> 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?
>

Probably because that isn=E2=80=99t how things work=E2=80=A6connection prop=
erties are set
using set property and gucs aren=E2=80=99t connection properties - though t=
here is
a pass-through connection property called options that can hold a list of
gucs to set.


>
> I learnt or from code, it's seen the key value pairs has higher precedenc=
e
> or override the guc values passed via cmdline option("options") field whe=
n
> 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 passe=
d
> as key value by driver with 'ISO' which has higher precedence.
>
>
IIUC the driver must control date style to operate correctly.  And as a
user you shouldn=E2=80=99t care because you=E2=80=99ll be using Java classe=
s to process
dates.

David J.

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

On Friday, June 20, 2025, Manav Kumar &lt;<a href=3D"mailto:mkumar@yugabyte=
.com">mkumar@yugabyte.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quot=
e" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=
<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-wrap">jd=
bc:postgresql://<a href=3D"http://10.150.3.175:6433/postgres?&amp;geqo=3Dof=
f" target=3D"_blank">10.150.<wbr>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;opti=
ons&quot; rather pass directly key value pairs similar to what JDBC driver =
internally does. =C2=A0</div></div></blockquote><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex"><div dir=3D"ltr"><div><br></div><div>Neither=C2=A0setProperty(&quot;geq=
o&quot;, &quot;off&quot;) works in this case.</div><div>Can someone let me =
know why I can&#39;t do it?=C2=A0</div></div></blockquote><div><br></div><d=
iv>Probably because that isn=E2=80=99t how things work=E2=80=A6connection p=
roperties are set using set property and gucs aren=E2=80=99t connection pro=
perties - though there is a pass-through connection property called options=
 that can hold a list of gucs to set.</div><div>=C2=A0</div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex"><div dir=3D"ltr"><div><br></div><div>I learnt or from code,=
 it&#39;s seen the key value pairs has higher=C2=A0precedence or override t=
he guc values passed via cmdline option(&quot;options&quot;) field when bot=
h passed in start 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><d=
iv><br></div></div></blockquote><div><br></div><div>IIUC the driver must co=
ntrol date style to operate correctly.=C2=A0 And as a user you shouldn=E2=
=80=99t care because you=E2=80=99ll be using Java classes to process dates.=
</div><div><br></div><div>David J.</div><div><br></div>

--000000000000f4bc5706380198f9--