MIME-Version: 1.0
References: 
 <CAPhCW+-oyivUiBiP5nOMQNxQzXLnT62SvCZ1oq7rqZkHq34KGA@mail.gmail.com>
 <CAB=Je-Gznb3j_M--EAn9zW0cHLzgMg_YyWxWGM==g_kRfxEzrA@mail.gmail.com>
In-Reply-To: 
 <CAB=Je-Gznb3j_M--EAn9zW0cHLzgMg_YyWxWGM==g_kRfxEzrA@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Mon, 19 May 2025 11:12:10 -0400
Message-ID: 
 <CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA@mail.gmail.com>
Subject: Re: Understanding DateStyle guc in startup packet
To: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Cc: Manav Kumar <mkumar@yugabyte.com>, pgsql-jdbc@lists.postgresql.org,
	Laurenz Albe <laurenz.albe@cybertec.at>
Content-Type: multipart/alternative; boundary="00000000000054f1fb06357e8fc2"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA%40mail.gmail.com>
Precedence: bulk

--00000000000054f1fb06357e8fc2
Content-Type: text/plain; charset="UTF-8"

On Mon, 19 May 2025 at 08:23, Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
wrote:

> Long story short: it might be nice to decouple pgjdbc from requiring
> DateStyle=ISO, however, it does not look like a walk in the park to me.
>
> I guess here's the line that configures DateStyle ISO:
> https://github.com/pgjdbc/pgjdbc/blob/d9e20874590f59543c39a99b824e09344f00a813/pgjdbc/src/main/java/org/postgresql/core/v3/ConnectionFactoryImpl.java#L409
>
> It looks like options come after DateStyle.
>
> At the same time, for some reason related to COPY processing, the driver
> asserts DateStyle must start with ISO:
> https://github.com/pgjdbc/pgjdbc/issues/131
>

Why would you want to change it? We keep it a specific way to simplify
parsing it internally. If you want to display it differently than you can
change the output format


> Dave Cramer
> www.postgres.rocks
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div><br></div></div><br=
><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D=
"gmail_attr">On Mon, 19 May 2025 at 08:23, Vladimir Sitnikov &lt;<a href=3D=
"mailto:sitnikov.vladimir@gmail.com">sitnikov.vladimir@gmail.com</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr"><div>Long story short: it might be nice to decouple pgjdbc from requi=
ring DateStyle=3DISO, however, it does not look like a walk in the park to =
me.</div><div><br></div><div>I guess here&#39;s the line that configures Da=
teStyle ISO:=C2=A0<a href=3D"https://github.com/pgjdbc/pgjdbc/blob/d9e20874=
590f59543c39a99b824e09344f00a813/pgjdbc/src/main/java/org/postgresql/core/v=
3/ConnectionFactoryImpl.java#L409" target=3D"_blank">https://github.com/pgj=
dbc/pgjdbc/blob/d9e20874590f59543c39a99b824e09344f00a813/pgjdbc/src/main/ja=
va/org/postgresql/core/v3/ConnectionFactoryImpl.java#L409</a></div><div><br=
></div><div>It looks like options come=C2=A0after DateStyle.</div><div><br>=
</div><div>At the same time, for some reason related to COPY processing, th=
e driver asserts DateStyle must start with ISO:=C2=A0<a href=3D"https://git=
hub.com/pgjdbc/pgjdbc/issues/131" target=3D"_blank">https://github.com/pgjd=
bc/pgjdbc/issues/131</a></div></div></blockquote><div><br></div><div>Why wo=
uld you want to change it? We keep it a specific way to simplify parsing it=
 internally. If you want to display it differently than you can change the =
output format</div><div><br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><br class=3D"gmail-Apple-interchange-newline">D=
ave Cramer<div>www.postgres.rocks</div><div><br></div></div>
</blockquote></div></div></div>

--00000000000054f1fb06357e8fc2--