10 POSTGRESQL

============================================================================== Simba PostgreSQL ODBC Driver Release Notes ==============================================================================

The release notes provide details of enhancements, features, and known issues in Simba PostgreSQL ODBC Driver 1.4.21, as well as the version history.

1.4.21 =======================================================================

Released 2020-12-11

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.21.

  • [PGODBC-1297] In some cases, when multiple threads are creating and destroying the environment handle, the driver hangs or terminates unexpectedly.

  • [PGODBC-1304] When SQL_ATTR_AUTOCOMMIT is set to SQL_AUTOCOMMIT_OFF after the connection, the driver incorrectly returns a “current transaction is aborted, commands ignored until end of transaction block” error.

  • [PGODBC-1319] When SQL_ATTR_ACCESS_MODE is set to SQL_MODE_READ_ONLY before the connection, the driver log incorrectly shows “Failed to execute query before connecting to the server: SET readonly = true” where the query is not executed.

    This issue has been resolved. The log now shows “Query is not executed because connection has not been established: SET readonly = true” in this case, and “Query executed: SET readonly = true” when the query is executed.

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

  • Timestamps do not accept negative values.

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

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

The following changes may disrupt established workflows for the driver.

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

  • Removing 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

    For a list of supported operating systems, see the Installation and Configuration Guide.

  • [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.4.19 ———————————————————————–

Released 2020-10-28

Resolved Issues The following issue has been resolved in Simba PostgreSQL ODBC Driver 1.4.19.

  • [PGODBC-1308] When SQLPutData is called multiple times for the same parameter, the data gets truncated.

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

Released 2020-10-13

Enhancements & New Features

  • [PGODBC-1291] Updated logging configurations

    You can now configure logging for the current connection by setting the logging configuration properties in the DSN or in a connection string. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1299] Updated third-party libraries

    The driver has been updated to use the following libraries:

    • OpenSSL 1.1.1g (previously 1.1.1d)
    • ICU 58.3 (previously 58.2)

  • Additional operating system support

    The driver now supports the following additional operating systems:

    • Windows Server 2019
    • Red Hat Enterprise Linux (RHEL) 8
    • CentOS 8
    • SUSE Linux Enterprise Server (SLES) 15
    • Ubuntu 18.04

  • [PGODBC-1233] Support for GEOMETRY data type

    The driver now supports data of type GEOMETRY. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1250] Updated TIME (WITH TIME ZONE) data type

    Data of type TIME (WITH TIME ZONE) is now mapped to to SQL_TYPE_TIME for ODBC 3.0 or SQL_TIME for ODBC 2.0. For more information, see the Installation and Configuration Guide.

  • [PGODBC-1156] Support for read-only mode

    You can now configure the driver to enable read-only mode. To do this, select the Enable Read Only check box (set the ReadOnly connection property to 1). For more information, see the Installation and Configuration Guide.

    Additionally, you can change the read-only settings by setting SQL_ATTR_ACCESS_MODE to SQL_MODE_READ_WRITE or SQL_MODE_READ_ONLY.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.18.

  • [PGODBC-1233] When using SQLParamData and SQLPutData to select and insert, the driver returns an error.

  • [PGODBC-1233] If autocommit is disabled and the query fails after execution, the driver returns a “current transaction is aborted, commands ignored until end of transaction block” error.

  • [PGODBC-1199] When using SQLSetDescRec() with SQL_TYPE_DATE and SQL_TYPE_TIMESTAMP, the driver returns an error.

  • [PGODBC-1275] When the connection object’s destructor calls SQLDisconnect(), the driver terminates unexpectedly.

    This issue has been resolved. When using the driver with an object that has static storage duration (such as a global), you may run into destruction order issues during application termination. The driver now returns SQL_ERROR when SQLDisconnect() is called in this case.

  • [PGODBC-1271] When using a column filter, SQLProcedureColumns() returns incorrect columns.

  • [PGODBC-1223] SQL_DATA_TYPE and SQL_DATETIME_SUB in SQLColumns return incorrect values for date and time data types.

    This issue has been resolved. The driver now returns SQL_DATETIME for all date and time types in SQL_DATA_TYPE for SQLColumns. Additionally, the driver now returns SQL_CODE_DATE, SQL_CODE_TIME, or SQL_CODE_TIMESTAMP, depending on the type of date or time column, or null otherwise, in SQL_DATETIME_SUB for SQLColumns.

  • [PGODBC-1201] When using SQLPrimaryKeys with a schema name, the driver returns incorrect results.

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

Released 2020-05-28

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.14.

  • [PGODBC-1196] When the date, time, or timestamp escape sequences are applied, the SQLBindParameter function returns an error.

  • [PGODBC-1209] When the ColumnName filter is applied, the SQLProcedureColumns function returns the incorrect column.

  • [PGODBC-1237] In some cases, the driver returns an error when arrays of
    parameters are bound.

1.4.11 ———————————————————————–

Released 2020-02-28

Enhancements & New Features

  • [PGODBC-1168] Support for notarization

    The driver now supports notarization on macOS systems, enabling it to be run on macOS versions 10.14.6 and 10.15.

  • [PGODBC-1183] Updated Expat library

    The driver has been updated to use Expat 2.2.9. Previously, the driver used Expat 2.2.0.

1.4.10 ———————————————————————–

Released 2019-11-29

Enhancements & New Features

  • [PGODBC-1147] Improved driver security

    The driver’s implementation of SQLTables and SQLColumns has been updated to provide stronger protection against SQL injections.

  • [PGODBC-1154] Updated driver version information in Linux binary

    You can now check the Linux driver’s version from the driver binary file. To do this, open the .so file in a text editor, and search for the text “\(driver_version_sb\):”. The driver’s version number is listed after this text.

  • [PGODBC-1146] Updated OpenSSL library

    The driver has been updated to use version 1.1.1d of the OpenSSL library.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.10.

  • [PGODBC-1146] The driver terminates unexpectedly when both of the following occur:
    • Multiple database drivers are loaded to the same process.
    • One driver unloads and calls ICU’s u_cleanup() function, while another driver continues to run and tries to access the memory space that has been cleaned up.
  • [PGODBC-1144] In some cases, when SQLForeignKeys is called, the returned data is not correctly filtered.

1.4.8 ————————————————————————

Released 2019-09-13

Enhancements & New Features

  • [PGODBC-1117] Updated third-party library linking for Linux

    The Linux driver now statically links to the OpenSSL and ICU libraries by default. Driver builds with dynamically linked libraries continue to be available as needed. For more information about this change, contact Customer Support through https://www.simba.com/support/.

  • [PGODBC-1045] Oracle Linux support

    The driver now supports Oracle Linux 7.5.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.8.

  • [PGODBC-1137] When an input parameter value is indicated as SQL_NULL_DATA during the SQLBindParameter call, the driver incorrectly binds the parameter using the SQL data type of the parameter specified in SQLBindParameter.

    This issue is resolved. The driver now binds the parameter value based on the data type of the column.

  • [PGODBC-1116] MaxLongVarChar data type has a maximum length of 8190.

1.4.7 ————————————————————————

Released 2019-06-28

Enhancements & New Features

  • [PGODBC-1051] PostgreSQL 11 support

    The driver now supports PostgreSQL 11. Previous versions supported Postgre SQL 9.4 through 10.

  • [PGODBC-1099] Improved driver performance

    Enhancements have been made to improve insertion performance when arrays of parameters are bound.

  • [PGODBC-1108] Updated OpenSSL

    The driver has been updated to use OpenSSL version 1.1.0j. Previously the driver was using version 1.1.0i.

Resolved Issues The following issues were resolved in Simba PostgreSQL ODBC Driver 1.4.6.

  • [PGODBC-717] Some registry entries are hard-coded to point to C:Files.

  • [PGODBC-1082] In some cases, when the UseUnicode option is enabled and the CONVERT function is called, errors occur when converting between character types.

  • [PGODBC-1102] Variables set in .ini files on Windows are not read correctly.

1.4.6 ————————————————————————

Released 2019-04-05

Enhancements & New Features

  • [PGODBC-997] Kerberos authentication

    The driver now supports Kerberos authentication. To use Kerberos, specify
    the Kerberos authentication option (set the UseKerberos configuration option to 1) and the Service Name (the KerberosServiceName configuration option). For more information, see the Installation and Configuration Guide.

  • [PGODBC-1069] Updated ICU library

    The driver has been updated to use version 58.2 of the ICU library. Previously the driver was using version 53.1.

  • [PGODBC-1084] Support for alternative server connections

    You can now specify a list of endpoint servers, and the driver attempts to connect to each of them sequentially until a valid server is found. For more information, see the Server configuration option in the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.6.

  • [PGODBC-1041] Some error messages display internal path information.

  • [PGODBC-1067] SQLGetTypeInfo does not return information about the FLOAT data type.

  • [PGODBC-1075] SQLGetTypeInfo returns duplicate rows for BPCHAR and NVARCHAR data types.

  • [PGODBC-1082] The driver returns SQLGetTypeInfo WCHAR even though it is not a supported Redshift data type.

  • [PGODBC-1082] The driver is missing the BIGINT data type in SQLGetInfo(SQL_CONVERT_BIT).

  • [PGODBC-1082] The following data types return no available conversions:

    • SQLGetInfo(SQL_CONVERT_WCHAR)
    • SQLGetInfo(SQL_CONVERT_WVARCHAR)
    • SQLGetInfo(SQL_CONVERT_WLONGVARCHAR)

    This issue has been resolved. Be aware that supported conversions are only returned if the “Use Unicode” option is turned on.

  • [PGODBC-1083] Catalog functions do not bind parameters correctly, causing errors like “bind supplies X parameters, but prepared statement requires Y”.

1.4.4 ————————————————————————

Released 2018-12-14

Enhancements & New Features

  • [PGODBC-541] Updated macOS support

    The driver now officially supports macOS 10.14. However, support for macOS 10.11 has been deprecated.

  • [PGODBC-1047] Dynamically linked third-party libraries

    The Linux driver has been updated to use dynamically linked libraries for ICU and OpenSSL. The installation directory now includes a “ThirdParty” directory which contains all required runtime libraries for the driver.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.4.

  • [PGODBC-994] In some cases, calling SQLProcedureColumns causes driver behavior that is inconsistent with when SQLColumns is called.

  • [PGODBC-1050] When the driver is installed on a machine that uses Turkish locale settings, if you try to connect using a connection string where one or more of the property names contains a lower-case “i” character, the driver does not connect to the server.

1.4.3 ————————————————————————

Released 2018-09-17

Enhancements & New Features

  • [PGODBC-1015] Upgraded OpenSSL library

    The driver now uses OpenSSL 1.1.0i.

  • [PGODBC-1004] Standardized log file names

    When logging is enabled, the driver now produces the following log files:

    • A simbapostgresqlodbcdriver.log file that logs driver activity that is not specific to a connection.
    • A simbapostgresqlodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection.

  • [PGODBC-996] More informative SSL error messages

    The driver now provides more detailed error messages for TLS/SSL errors.

Resolved Issues The following issues have been resolved in Simba PostgreSQL ODBC Driver 1.4.3.

  • [PGODBC-1016] When attempting to retrieve an OID value that is greater than 2147483647, the driver returns an error.

  • [PGODBC-1005] When the driver is configured to connect to PostgreSQL through a proxy server, if the Server property is set to an IP address instead of a host name, the driver does not recognize the IP address and fails to connect to PostgreSQL.

  • [PGODBC-936] When SQLGetTypeInfo is called, the driver returns an incomplete list of the supported PostgreSQL data types.

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