10 POSTGRESQL

============================================================================== Simba PostgreSQL ODBC Data Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba PostgreSQL ODBC Connector 1.6.1, as well as the version history.

==============================================================================

Platform and Data source version support

This version of the driver supports the following data source versions and platforms (Note: Platforms included with a distribution may vary according to what has been licensed):

  • PostgreSQL versions 12 through 17
  • Windows 11, Windows Server 2025, 2022, 2019, 2016, 2012
  • macOS (Universal Binary – Intel and ARM): 12, 13, 14
  • Linux (x86, x86_64 and ARM64): RHEL 8/9/10, SLES 15, Debian 11/12/13, Ubuntu 22.04/24.04

1.6.1 ========================================================================

Released November 2025

Enhancements & New Features

  • [PGODBC-1828][PGODBC-1839] Updated platform support

    The connector now supports the following platform versions:

    • Debian 13
    • Red Hat Enterprise Linux (RHEL) 10
  • [PGODBC-1870] Linux ARM Support

    On Linux platform , the connector now supports ARM architecture.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.

  • Timestamps do not accept negative values.

    The connector does not support the use of negative values in timestamps.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the connector.

1.6.1 ————————————————————————

  • [PGODBC-1878] Removed support for earlier versions of operating systems

    Beginning with this release, the connector no longer supports Windows 10 operating system.

1.6.0 ————————————————————————

  • [PGODBC-1660] Removed support for earlier versions of operating systems

    Beginning with this release, the connector no longer supports the following operating systems:

    • CentOS 8
    • macOS 11
    • Oracle Linux 7.5
    • SUSE Linux Enterprise Server (SLES) 12
    • Ubuntu 20.04

1.5.17 ———————————————————————–

  • [PGODBC-1660] Removed support for Visual Studio 2015

    Beginning with this release, support for Visual C++ Redistributable for Visual Studio 2015 has been removed. For supported versions, see the Installation and Configuration Guide.

  • [PGODBC-1713] Removed support for earlier versions of operating systems

    Beginning with this release, the connector no longer supports the following operating systems:

    • CentOS 7
    • Debian 8, 9, and 10
    • RHEL 7
    • Ubuntu 16.04 and 18.04
  • [PGODBC-1733] PostgreSQL versions 9.x to 11.0, have been deprecated.

1.5.2 ————————————————————————

  • [PGODBC-1590] Removed support for macOS versions

    Beginning with this release, the macOS connector no longer supports version 10.13 to 10.15. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1595] Removing support for Windows 8.1

    As early as August 2023, the connector will no longer support Windows 8.1.

1.4.54 ———————————————————————–

  • [PGODBC-1104] Updated PostgreSQL 12 behavior

    The following behaviors have been updated for PostgreSQL 12:

    • All of the key column’s names are used when selecting default constraint names for foreign keys.
    • Improved rounding performance of real and double precision values.

    For more information, see https://www.postgresql.org/docs/12/release-12.html.

  • [PGODBC-1521] Updated Minimum TLS default value

    The default value for Minimum TLS is now 1.2. Previously, it was 1.0. For more information, see the Installation and Configuration Guide.

1.4.28 ———————————————————————–

  • [PGODBC-1038] Updated EnforceSingleStatement and UseMultipleStatements description

    The description of the EnforceSingleStatement and UseMultipleStatements options have been changed to reflect the actual behavior. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1038] Updated query processing modes behavior

    The connector’s behavior for the query processing modes have been updated. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1358] Removed support for CentOS 6 and RHEL 6

    Beginning with this release, support for CentOS 6 and RHEL 6 have been removed.

1.4.18 ———————————————————————–

  • Removed support for earlier versions of operating systems

    Beginning with this release, the driver no longer supports the following operating systems:

    • Windows 7 SP1
    • Windows Server 2008 R2 SP1
    • SUSE Linux Enterprise Server (SLES) 11
    • Debian 7
    • Ubuntu 14.04
  • [PGODBC-1277] New default value for Bytea As LongVarBinary

    The default value of the Bytea As LongVarBinary option (ByteaAsLongVarBinary connection property) is now Enabled (1). Previously, the default value was Disabled (0). For more information, see the Installation and Configuration Guide.

1.4.14 ———————————————————————–

  • [PGODBC-1186] Removed support for the Visual C++ Redistributable for Visual Studio 2013

    Beginning with this release, the driver now requires the 2015 version of this dependency instead of the 2013 version.

    To download the installation packages for the Visual C++ Redistributable for Visual Studio 2015, go to https://www.microsoft.com/en-ca/download/details.aspx?id=48145

Version History ==============================================================

1.6.0 ————————————————————————

Released 2025-07-28

Enhancements & New Features

  • [PGODBC-1781] Updated Windows Server support

    The connector now supports Windows Server 2025.

  • [PGODBC-1703] Updated SEN SDK support

    The connector now uses SEN SDK version 10.3. Previously, the connector used SEN SDK version 10.2.

  • [PGODBC-1755][PGODBC-1756][PGODBC-1757][PGODBC-1766] Updated third-party libraries

    The connector now uses the following third-party libraries:

    • Expat 2.7.1 (previously 2.6.4)
    • libcurl 8.12.0 (previously 8.10.1)
    • libpq 14.16 (previously 14.2)
    • OpenSSL 3.0.16 (previously 3.0.15)
  • [PGODBC-1734] Updated PostgreSQL version support

    The connector now supports PostgreSQL versions 12 through 17.

  • [PGODBC-1773] Updated support for multiple operating systems

    The connector now supports the following operating systems:

    • Debian 12
    • macOS 13 and 14
    • RHEL 9

1.5.20 ———————————————————————–

Released 2024-12-31

Enhancements & New Features

  • [PGODBC-1749] Updated third-party libraries:

    The connector now uses the following third-party libraries:

    • Expat 2.6.3 (previously 2.6.2)
    • OpenSSL 3.0.15 (previously 3.0.13)

1.5.17 ———————————————————————–

Released 2024-08-30

Enhancements & New Features

  • [PGODBC-1658][PGODBC-1708] Updated third-party libraries

    The connector now uses the following third-party libraries:

    • Expat 2.6.2 (previously 2.6.0)
    • OpenSSL 3.0.13 (previously 3.0.12)
  • [PGODBC-1710] Updated Ubuntu version support

    The connector now supports Ubuntu 24.04.

Resolved Issues The following issue has been resolved in Simba PostgreSQL ODBC Connector 1.5.17.

  • [PGODBC-1652] In ODBC 2.0, when SQLProcedureColumns is called, the SEQ_IN_INDEX column is incorrectly named.

1.5.11 ———————————————————————–

Released 2023-12-20

  • [PGODBC-1648][PGODBC-1650] Updated OpenSSL library

    The connector has been updated to use version 3.0.12 of the OpenSSL library. Previously, the connector used 3.0.9.

  • [PGODBC-1649] Internal security-related improvements

    The connector has been updated with security-related improvements.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Connector 1.5.11.

  • [PGODBC-1640] When SQLColumns() function is called, the connector returns 0 instead of NULL for NUM_PREC_RADIX and CHAR_OCTET_LENGTH.

  • [PGODBC-1642] In some cases, custom SQLState overriddes to SQLState S1000 for errors and 01000 for warnings.

  • The connector computes the value returned for SQL_DESC_OCTET_LENGTH from the IRD (and thus also SQLColAttribute) for character types by using the maximum size of a codepoint, instead of the size of a code unit. For both wide and non-wide types, the column size was previously used directly for non-wide types as the code unit size was assumed to be 1.

1.5.2 ————————————————————————

Released 2023-07-06

Enhancements & New Features

  • [PGODBC-1572] Updated OpenSSL support

    The connector now uses OpenSSL version 3.0.9. Previously, the connector used OpenSSL version 1.1.1n.

  • [PGODBC-1566] New attribute to retrieve SSL information

    You can now retrieve the SSL information of a connection using the PGO_CONN_SSL_INFO custom attribute with SQLGetConnectAttr. The value of PGO_CONN_SSL_INFO is 16385.

  • [PGODBC-1595][PGODBC-1602] Updated platform support

    The connector now supports the following platform versions:

    • Windows 11
    • Windows server 2022
    • Debian 10 and 11
    • Ubuntu 22.04
  • [PGODBC-1576] Updated macOS Support

    On macOS, the connector is now a Universal driver that natively supports Apple Silicon.

Resolved Issues The following issue has been resolved in Simba PostgreSQL ODBC Connector 1.5.2.

  • [PGODBC-1567] When SingleRowMode is enabled and two queries are executed in a row, the connector returns a “Query cancelled on user’s request” error
    for the latter query.

==============================================================================

Installation and Configuration Guide