What's new in PostgreSQL ODBC driver 4.5.1
Mar 28, 2024
- Fixed the issue when establishing a connection with a connection string that contains unsupported parameters
New in PostgreSQL ODBC driver 4.5.0 (Mar 14, 2024)
- Added support for PostgreSQL 16
- Now passwords are stored in an encrypted form in the DSN record
- Improved compatibility with FileMaker Server for Linux and macOS
- Fixed connection timeout setting before opening connection
- Fixed bug with handling the numeric data type
New in PostgreSQL ODBC driver 4.4.2 (Oct 4, 2023)
- Fixed bug with driver license validation for Linked Server in MSSMS
New in PostgreSQL ODBC driver 4.4.1 (Aug 18, 2023)
- Improved compatibility with 4D in macOS
- Fixed bug with getting data in DBeaver
- Fixed Windows XP installation bug
New in PostgreSQL ODBC driver 4.4.0 (May 17, 2023)
- Added support for PostGIS
- Added support for SQL_ATTR_MAX_ROWS attribute
- Improved compatibility with Visual Basic in Visual Studio
- Fixed bug with using Min Fetch Rows
New in PostgreSQL ODBC driver 4.3.0 (Nov 18, 2022)
- Added support for PostgreSQL 15
- Added support for macOS 13 Ventura
- Added support for the SCRAM-SHA-256-PLUS authentication mechanism
- Improved compatibility with Tableau Prep Builder
- Improved compatibility with Crystal Reports
- Improved the SSH connection establishment
- Fixed bug with TIMESTAMPTZ fields
- Fixed bug when a connection string parameter value contains a single quote
- Fixed an issue with adding DSN in PowerShell
- Fixed an issue with rows deleting
New in PostgreSQL ODBC driver 4.2.1 (Jan 5, 2022)
- Added support for Windows 11
- Added support for PostgreSQL 14
- Added support for OUT parameters in stored procedures in PostgreSQL 14
- Improved compatibility with PostgreSQL 8.1 and 8.2
- Improved compatibility with FICO Mosel
- Improved compatibility with FileMaker
- Improved compatibility with JMP on macOS
- Improved support for an ODBC installer on Windows 2000
- Fixed an issue with updating date and time fields in MS Access
- Fixed a double function call
- Fixed UUID with braces
New in PostgreSQL ODBC driver 4.1.1 (Jul 12, 2021)
- MSI installer for deploying through GPO is added
- Bug with executing the "call" macro with a stored procedure in PostgreSQL 11 and later is fixed
New in PostgreSQL ODBC driver 4.0.1 (May 28, 2021)
- Apple Silicon M1 is supported
- Compatibility with macOS Big Sur is improved
- Bug with modifying data using the Linked Server is fixed
New in PostgreSQL ODBC driver 3.4.1 (Dec 9, 2020)
- PostgreSQL 13 is supported
- Compatibility with Clarion Enterprise is improved
- Bug with accessing tables whose names contain spaces is fixed
- Bug with reading milliseconds from TIMESTAMP columns is fixed
- Bug with setting the SERIALIZABLE transaction isolation level is fixed
New in PostgreSQL ODBC driver 3.3.4 (Apr 8, 2020)
- Materialized views are supported
- Compatibility with Power Pivot is improved
- Compatibility with Visual Basic is improved
- Compatibility with RStudio is improved
- Bug with modifying data using SQLSetPos is fixed
- Bug with fetching by Bookmark is fixed
New in PostgreSQL ODBC driver 3.2.3 (Dec 2, 2019)
- PostgreSQL 12 is supported
New in PostgreSQL ODBC driver 3.1.2 (Oct 7, 2019)
- Amazon RDS for PostgreSQL is supported
- Work with password-protected private key for SSH protocol is supported
- Now ODBC driver activation does not require administrator privileges
- Improved compatibility with sandboxed applications for macOS
- Support for connection pooling is improved
New in PostgreSQL ODBC driver 3.0.1 (Jan 9, 2019)
- PostgreSQL 11 is supported
- Now ODBC driver for macOS is distributed as a PKG package
- Now ODBC driver for Linux is distributed as DEB and RPM packages
- Possibility to force the ODBC 2.x behavior is added
New in PostgreSQL ODBC driver 2.4.9 (Jul 17, 2018)
- Possibility to show used connection string in the connection dialog is added
- Bug with function execution using SQLExecDirect is fixed
New in PostgreSQL ODBC driver 2.4.8 (Jun 15, 2018)
- Possibility to return String Types as Ansi or Unicode is added
- Compatibility with MS Access is improved
- Compatibility with Tableau is improved
- Compatibility with Omnis Studio is improved
- Compatibility with Power Pivot is improved
- Compatibility with DBeaver is improved
New in PostgreSQL ODBC driver 2.3.7 (Feb 27, 2018)
- Performance of batch operations is significantly improved
- The SSHStoragePath connection parameter is added
- Support for the use of "?", "?|" and "?&" JSON operators in SQL statements by escaping the question mark character ("?", "?|" and "?&" respectively) is added
New in PostgreSQL ODBC driver 2.2.6 (Oct 24, 2017)
- PostgreSQL 10 is supported
- Azure Database for PostgreSQL is supported
- Compatibility with SAS JMP is improved
- Compatibility with MS Power Query is improved
- OUTER JOIN macros in SQL queries are supported
- DateTime macros in SQL queries are supported
- Scalar function macros in SQL queries are supported
New in PostgreSQL ODBC driver 2.1.5 (Jun 22, 2017)
- Compatibility with Adobe ColdFusion is improved
- Several issues with data modification in Microsoft SQL Server Management Studio are resolved
- Now "." is a decimal separator for numbers with floating point by default
- Bug with handling numeric data type is fixed
New in PostgreSQL ODBC driver 2.1.4 (Dec 8, 2016)
- Compatibility with Microsoft SQL Server Reporting Services is improved
New in PostgreSQL ODBC driver 2.1.3 (Dec 8, 2016)
- Compatibility with MS Visual Studio
- Compatibility with MS FoxPro is improved
- Compatibility with MapInfo is improved
- Compatibility with Libre Office is improved
- Compatibility with Qlik is improved
- Compatibility with Delphi & C++Builder is improved
- MS Access linked tables support is improved
- The SELECT ... FOR UPDATE statement is supported
New in PostgreSQL ODBC driver 2.0.2 (Apr 7, 2016)
- Compatibility with MS Excel is improved
- Compatibility with ODBC 2.x is improved
- Bug with Trial expiration in Microsoft SQL Server Management Studio is fixed
- Support for server versions 7.3-8.3 is improved
- Bug with fetching big data amount is fixed
New in PostgreSQL ODBC driver 2.0.1 (Mar 23, 2016)
- Support for stored procedures and functions is improved
- Backward compatibility of SQLExecDirect with ODBC 2.x is improved
New in PostgreSQL ODBC driver 1.3.4 (Jan 9, 2016)
- Connection via SSL protocol is supported
- Connection via SSH protocol is supported
- Connection via HTTP tunnel is supported
- Compatibility with Microsoft Power BI Desktop is improved
- Compatibility with Microsoft Visual FoxPro is improved
New in PostgreSQL ODBC driver 1.2.3 (Nov 23, 2015)
- Compatibility with Microsoft Visual Studio is improved
- Compatibility with Microsoft Office is improved
- Compatibility with Microsoft SQL Server Management Studio is improved
- Compatibility with Crystal Reports is improved
- Compatibility with ClikView is improved
- Compatibility with SQL Server Data Tools is improved
New in PostgreSQL ODBC driver 1.1.1 (Jul 7, 2015)
- First release of ODBC Driver for PostgreSQL
- Windows 32-bit is supported
- Windows 64-bit is supported