We have run into some interesting results with the current version.
First, when running select top 1000 from SQL server using a view to a PGNP linked server we get this Error:
OLE DB provider "PGNP" for linked server "PGNP_LinkServer" returned message "ERROR: syntax error at or near "LIMIT"
LINE 2: ...n.namesid=rel.namesid WHERE js.active LIMIT 10000 LIMIT 1000...
To me it looks like the code added two limit statements to the end of the query. If I take the Top statement away it runs normally. This used to run fine in version 1.4.0.3254
Next, When we have a view, the sql statement runs in 11 seconds natively, yet times out pulling rows from the server using the PGNP linked server, and takes 30 to 50 seconds. This is the error I get when it times out:
OLE DB provider "PGNP" for linked server "PGNP_JMS2" returned message "timeout expired
".
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "PGNP" for linked server "PGNP_LinkServer".
Interestingly enough I can add an outrageous record amount as a limit (example limit 10000) to the postgresql query and it will return in 2 seconds. Maybe an issue with allocating memory?
Other then these issues works great for us.
Thanks,
