| From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
|---|---|
| To: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
| Cc: | Manav Kumar <mkumar(at)yugabyte(dot)com>, pgsql-jdbc(at)lists(dot)postgresql(dot)org, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Subject: | Re: Understanding DateStyle guc in startup packet |
| Date: | 2025-05-19 15:12:10 |
| Message-ID: | CADK3HHKC-1iTEZNT4fvjS-mBkLYVmKQVG3Kvq9_KHXnctACUjA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Mon, 19 May 2025 at 08:23, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Sitnikov | 2025-05-19 15:37:24 | Re: Understanding DateStyle guc in startup packet |
| Previous Message | Vladimir Sitnikov | 2025-05-19 12:23:11 | Re: Understanding DateStyle guc in startup packet |