version 7.20 and postgresql 14

[domdee]

Are there / do you know any cons to use the driver 7.20 from Postgresql 14?

I did quick tests and it looks like the driver works normally. However, maybe you have some professional test procedure to verify this

[DmitryGm]

Most likely no problems are expected with PostgreSQL 14, and everything will work properly. However, we are currently doing full testing. As soon as testing is completed, we shall declare compatibility dotConnect for PostgreSQL with PostgreSQL 14 in the documentation.
https://www.devart.com/dotconnect/postg ... ility.html

[DmitryGm]

There is a new release dotConnect for PostgreSQL 7.22.2014
https://www.devart.com/dotconnect/postg ... nload.html

The new features of PostgreSQL Server 14 are supported:

• multirange data types
  • the database types int4multirange, int8multirange, nummultirange, datemultirange, tsmultirange, tstzmultirange can be used with the provider now
  • the new members IntMultirange, BigIntMultirange, NumericMultirange, TimeStampMultirange, TimeStampTZMultirange, DateMultirange are added to the PgSqlType enum
  • PgSqlReader.GetProviderSpecificValue returns provider-specific range types: PgSqlIntRange[] for int4multirange, PgSqlBigIntRange[] for int8multirange, PgSqlNumericRange[] for nummultirange, PgSqlTimeStampRange[] for datemultirange, PgSqlTimeStampTZRange[] for tsmultirange, PgSqlDateRange[] for tstzmultirange
• NaN, Infinity, -Infinity values of numeric data types generate a NotSupportedException to avoid inconsistency
• OUT parameters of stored procedures