What's New in 1.5?
The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum, Redshift and Denodo has several new features and improvements:
- New Ansi Mode represents char fields as UTF8.
- IDP/SSO Login support for Redshift.
- 64-bit Profiler for unlimited tracing.
- Subscriptions support.
The PGNP v1.5 release modules and documentation are available on the Download V1.5 page.
See also: What's new in 1.4?
PGNP Project History
August 17, 2026 Ver 1.5.0.4074
Added new connection string parameter ADD_PADDING for bpchar.
Stability enhancements via migration to the latest libpq, openssl, kerberos, and via various fixes.
Fixed overflow issue in SUM(numeric).
Fixes for SSL (certs loading bug, etc.)
Updated License Agreement.
February 9, 2026 Ver 1.5.0.4066
Fixed issue with duplicate service column name (SELECT * FROM pg_am)
Fixed bug in processing LIKE-ESCAPE expression.
Enhanced text to timestamp conversion.
PGNPUpdate: added Load License button to the Options dialog. Added minor fixes in UI.
October 12, 2025 Ver 1.4.0.3734
Improved parameters handling: better error reporting, fixed types validation, shortened too long messages, etc.
Fix for the Undefined CTE table when SYNTAX=T-SQL.
Fixed bug in processing CTEs with UNION queries that reference the CTE name.
Fixed bug in handling concatenated trims and trim(cast...).
Redshift: Fixed metadata handling for procedures parameters.
Fixed bug in determining columninfo for date_trunc().
Fixed bug in querying pg_roles.
Fix for "The (maximum) expected data length is 60, while the returned data length is 26".
Fixed bug in determining column size for a Case-Else clause.
Added exceptions handling when processing TimeZones file.
Fixed printing of Currency and Numeric parameters for PGNProfiler trace.
PGNProfiler: fixed coloring for TRUNCATE.
October 5, 2025 Ver 1.5.0.4058
Fixed bug in processing CTEs with UNION queries that reference the CTE name.
Fixed bug in determining column size for a Case-Else clause.
Eliminated unnecessary parameters conversions.
Improved parameters handling by shortening very long error messages and adding the executed statement with the error.
Fixed printing Currency and Numeric parameters for the PGNProfiler trace.
PGNP Features Matrix (32- and 64-bit Platforms); DE vs SE
| FEATURE | PGNP 1.3.0 | PGNP 1.4.0* | PGNP 1.5.0* |
|---|---|---|---|
| PostgreSQL Support | 8.x, 9.x | 9.x-15.x | 9.x-latest |
| OLE DB Connection Pooling | Yes | Yes | Yes |
| OLE DB Error Reporting | Yes | Yes | Yes |
| OLE DB Command Prepare and Cancel | Yes | Yes | Yes |
| OLE DB Columns Information | Yes | Yes | Yes |
| Database Transformation in SQL Server DTSWizard | Yes | Yes | Yes |
| Local Transaction Support | Yes | Yes | Yes |
| Distributed Transactions and Two Phase Commit Protocol (DTC enlistment) | No | Yes** | Yes** |
| SQL Server 2005-2025 Linked Servers Support | Yes | Yes | Yes |
| SQL Server 2005-2025 to PostgreSQL Replication Support | Yes | Yes | Yes |
| Multiple Result Sets, Multiple SQL statements/MARS | From Procedures Only | Full | Full |
| Execution Tracing and Profiling | PGNProfiler x86 | PGNProfiler x86 | PGNProfiler x64 |
| Schema Support (tables, views, provider types, columns, primary/foreign keys, indexes, procedures, etc.) | Yes | Yes | Yes |
| SSL, Kerberos, GSSAPI and SSPI Support | Yes | Yes | Yes*** |
| Extended parameters syntax support ('@', ':' and '?') | Yes | Yes | Yes |
| IN, OUT and INOUT Parameters Support | Yes | Yes | Yes |
| Recycling of the Internal MetaData Cache | Automatic | Automatic | Automatic |
| Nested Transactions Support | Yes | Yes | Yes |
| COPY Command and high-performance import support in SSIS (FastLoad) | Yes | Yes | Yes |
| OLE DB Command Timeout and Cancellation | No | Yes | Yes |
| Array Types Support | No | Yes | Yes |
| IRowsetUpdate Support | No | Yes | Yes |
| Automated Product Updates Support | No | Yes | Yes |
| IDP/SSO Login support | No | No | Yes |
| Subscriptions support | No | No | Yes |
| Ansi Mode to expose char fields as UTF8. | No | No | Yes |
* The PGNP v1.5 release modules and documentation are available on the Download V1.5 page.
** Server Edition only.
*** Pluggable/componentized.
Desktop Edition vs Server Edition
The above table shows common features/capabilities for both DE and SE products. The table below summarizes differences between DE and SE in the latest release.
| FEATURE | Desktop Edition | Server Edition |
|---|---|---|
| Fast and scalable (beyond 1 million rows) rows engine | No | Yes |
| Two Phase Commit Protocol (distributed transactions) | Not supported | Supported |
| Table statistics metadata | Not supported | Supported |
| Integration with linked servers/SSIS/SSRS/SSAS | Minimal | Full |
PGNP OLEDB Providers for PostgreSQL*, Greenplum and Redshift
The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The provider can be used from 32-bit and 64-bit applications both native and .NET.Main features are:
- High performance in all OLTP and OLAP scenarios.
- Full support for SSRS, SSAS and SSIS in SQL Server 2005-2022.
- OS Platforms: Windows XP, Windows Servers 2003-2022, Windows Vista, Windows 7-11.
- SQL Server Linked Servers and Replication support.
- Error reporting and execution tracing.
- Transactions support: standard OLEDB, and "nested" PostgreSQL transaction using savepoints.
- Distributed transactions, two phase commit protocol.
- Schema support for tables, views, provider types, columns, primary/foreign keys, indexes, etc.