We are testing out the PGNP (PGNP-1.3.0.2217) from an SQL 2005 against a PostgresSQL 8.1.13. The testing is going very smoothly for the Update, Delete, and Select commands. The Insert commands work correctly when running against a table that does not have a serial column. We get the follow error when attempting to insert a record to a table that has a serial column (primary key).
SQL Statement:
INSERT INTO [PGSample].[ittest2].[public].[testtable]
([firstname],[lastname])
VALUES
('Thomas','James')Error Output:
OLE DB provider "PGNP" for linked server "PGSample" returned message "ERROR: syntax error at or near "RETURNING"
LINE 1: ...testtable"("firstname","lastname") VALUES ($1,$2) RETURNING ...
^
".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "PGNP" for linked server "PGSample" could not INSERT INTO table "[PGSample].[ittest2].[public].[testtable]".I have tried several variations with the Extended Attributes: SQLSYNTAX.
Tom
Thomas Burl
