Page 1 of 1

version 7.20 and postgresql 14

Posted: Thu 21 Oct 2021 06:35
by 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

Re: version 7.20 and postgresql 14

Posted: Thu 21 Oct 2021 16:10
by 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

Re: version 7.20 and postgresql 14

Posted: Wed 10 Nov 2021 08:42
by 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