Date: Tue, 05 Dec 2023 23:30:46 -0800
From: Vladimir Sitnikov <noreply@github.com>
To: pgsql-jdbc-commits@lists.postgresql.org
Message-ID: <pgjdbc/pgjdbc/push/refs/heads/master/25fdfc-c1a851@github.com>
Subject: [pgjdbc/pgjdbc] c1a851: fix: avoid timezone conversions when sending
 Local...
Mime-Version: 1.0
Content-Type: text/plain;
 charset=UTF-8
Content-Transfer-Encoding: 7bit
Approved: 58GruLoMopuc
Archived-At: 
 <https://www.postgresql.org/message-id/pgjdbc/pgjdbc/push/refs/heads/master/25fdfc-c1a851%40github.com>
Precedence: bulk

  Branch: refs/heads/master
  Home:   https://github.com/pgjdbc/pgjdbc
  Commit: c1a851c02b8690cda8e7b11a594f73ed27aa3189
      https://github.com/pgjdbc/pgjdbc/commit/c1a851c02b8690cda8e7b11a594f73ed27aa3189
  Author: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
  Date:   2023-12-06 (Wed, 06 Dec 2023)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/TimestampUtils.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc42/SetObject310Test.java

  Log Message:
  -----------
  fix: avoid timezone conversions when sending LocalDateTime to the database

Previously, LocalDateTime was converted to OffsetDateTime using the default
timezone, which made certain values unrepresentable.
For instance, 2023-03-12T02:00 in America/New_York is hard to represent
as it undergoes DST change.

It does not change resultSet.getObject(int | string), and resultSet.getString(int | string)
and those methods would still have issues when accessing timestamps
like 2023-03-12T02:00 when the client time zone is America/New_York

Co-authored-by: Kevin Wooten <kevin@wooten.com>

Fixes https://github.com/pgjdbc/pgjdbc/issues/1390
Fixes https://github.com/pgjdbc/pgjdbc/issues/2850
Closes https://github.com/pgjdbc/pgjdbc/pull/1391