Unable to set guc via setProperty - Mailing list pgsql-jdbc

From Manav Kumar
Subject Unable to set guc via setProperty
Date
Msg-id CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com
Whole thread Raw
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Understanding DateStyle guc in startup packet
Next
From: "David G. Johnston"
Date:
Subject: Re: Unable to set guc via setProperty