Re: version 42.2.3 postgresql 12.5 compatibility

On Thu, May 6, 2021 at 4:27 AM Branislav Kalas <bkalas(at)gmail(dot)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 <https://github.com/pgjdbc/pgjdbc/pull/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.

Regards,
-- Sehrope Sarkuni
Founder & CEO | JackDB, Inc. | https://www.jackdb.com/