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.
PGNP Project History
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 |
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?