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