public inbox for [email protected]  

help / color / mirror / Atom feed

From: Manav Kumar <[email protected]>
To: [email protected]
Subject: Unable to set guc via setProperty
Date: Fri, 20 Jun 2025 17:49:34 +0530
Message-ID: <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com> (raw)

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

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Unable to set guc via setProperty
  In-Reply-To: <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox