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.3, as well as the version history.

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.

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.

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

1.4.2 ————————————————————————

Released 2018-06-28

Enhancements & New Features

  • [PGODBC-339] Authentication support added for proxy connections

    You can now provide credentials to authenticate proxy connections. To do this, set the Proxy Username (or ProxyUid) option to your user name for accessing the proxy server, and set the Proxy Password (or ProxyPwd) option to the corresponding password. For more information, see the Installation and Configuration Guide.

  • [PGODBC-977] Materialized views supported

    The driver now supports materialized views. You can query and modify them like standard PostgreSQL views.

  • [PGODBC-925] Support for retrieving non-US currency values as Decimal data

    The driver can now retrieve data of type Money as data of type Decimal regardless of the currency that the value is specified as.

  • [PGODBC-988] Upgraded OpenSSL library

    The driver now uses OpenSSL 1.1.0h. Previously, the driver used OpenSSL 1.1.0g.

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

  • [PGODBC-985] In some cases, when calling APIs, the driver does not escape filter parameters correctly.

  • [PGODBC-982] When configuring the driver using the ODBC Administrator on Windows, if you configure proxy connection settings and then click the “Test” button, the ODBC Administrator terminates unexpectedly.

  • [PGODBC-983] If the server name contains hexidecimal characters only, the driver terminates unexpectedly when attempting to connect to the server.

  • [PGODBC-239] When configuring the driver using the ODBC Administrator on Windows, if you enter a DSN name that contains special characters and then click the “Test” button, the ODBC Administrator terminates unexpectedly.

    This issue has been resolved. The driver now returns an error message instead of causing the ODBC Administrator to terminate unexpectedly.

1.4.1 ————————————————————————

Released 2018-01-31

Enhancements & New Features

  • Improved support for character sets in internal processes

    The driver now supports non-ASCII character sets in connection attributes and error messages.

Resolved Issues The following issue was resolved in Simba PostgreSQL ODBC Driver 1.4.1.

  • In some cases, when calling SQLBindParameter and then SQLPrepare, the driver truncates the data and returns an error.

    This issue has been resolved. Before, the driver used a fixed VarChar column length of 255. If the data length was longer than 255 characters, the driver would truncate the data and return the following message:

    “[ODBC] (10170) String data right truncation on data from data source: String data is too big for the driver’s data buffer”

    The driver now uses the column length specified in the Max VarChar option (the MaxVarChar property) instead of a fixed value, so you can specify a larger maximum VarChar column size and avoid this issue.

1.4.0 ————————————————————————

Released 2017-12-20

Enhancements & New Features

  • Internal driver improvements

    The driver has been updated with minor internal improvements.

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