Home > mailing lists

Re: Understanding DateStyle guc in startup packet - Mailing list pgsql-jdbc

From	Dave Cramer
Subject	Re: Understanding DateStyle guc in startup packet
Date	May 19 18:12:10
Msg-id	CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA@mail.gmail.com Whole thread Raw
Responses	Re: Understanding DateStyle guc in startup packet
List	pgsql-jdbc

Tree view

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

pgsql-jdbc by date:

From: Laurenz Albe
Date: 29 March, 19:21:09
Subject: Fwd: PostgreSQL JDBC 42.7.5 returns an unexpected catalog name

From: Vladimir Sitnikov
Date: 19 May, 18:37:24
Subject: Re: Understanding DateStyle guc in startup packet

Re: Understanding DateStyle guc in startup packet - Mailing list pgsql-jdbc

Previous

Next