On Thu, May 6, 2021 at 4:27 AM Branislav Kalas <bkalas@gmail.com> wrote:
What is confusing me i went through changelogs of drivers and in 42.2.6 i saw this message
Added
CI tests with Java 11, and Java EA
Support temporary replication slots in ReplicationCreateSlotBuilder PR 1306
Support PostgreSQL 11, 12
Does that mean that 42.2.6 is first version supporting pg 12, or 42.2.3 should work with pg12 as well?
The older driver should work fine with basic query execution (e.g., java.sql.Statement, PreparedStatement, ResultSet, etc) as that protocol has not changed in years. However there is no guarantee as those older driver versions have not been tested against the newer server versions.
Newer server versions also sometimes change the presentation or handling of internal metadata. That can break the driver's handling of parts of the JDBC spec or it may simply leave out some information. For example, when partitioned tables were first added the older versions of the driver did not show them in metadata views because it did not know how to query for their details.
It's recommended that you always use the latest version of the driver as there are other fixes that go into each new version.