FEATURE PGNP 1.2.8  PGNP 1.3.0  PGNP 1.4.0*
PostgreSQL Support 8.0 8.x, 9.x 8.x-10.x
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 2000, 2005 and 2008 Linked Servers Support Yes Yes Yes
SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support Yes Yes Yes
Multiple Result Sets, Multiple SQL statements/MARS From Procedures Only From Procedures Only Full
Execution Tracing and Profiling TraceMgr PGNP Profiler PGNP Profiler

Schema Support (tables, views, provider types, columns, primary/foreign keys,

indexes, procedures, etc.)

Yes Yes Yes
SSL, Kerberos, GSSAPI and SSPI Support No 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 Manual *** Automatic Automatic
OLE DB Command Timeout  No  Yes Yes
Array Type Support  No  Yes Yes
Nested Transactions Support  No  Yes Yes
COPY Command and high-performance import support in SSIS (FastLoad)  No  Yes Yes
IRowsetUpdate Support  No  No Yes
Automated Product Updates Support  No  No Yes
       

 

* Evaluation version and documentation are available on the Download page.

** Server Edition only.

*** The internal stored procedure pgnp_refreshmetadata allows recycling of internal metadata cache in all connected instances of the provider. See Developer's Manual for more information.

 

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