Re: [GENERAL] Linked server query problem

2008-12-04 Thread Hiroshi Saito
Hi. Probably, it need the new feature of Ver 8.4. See, http://archives.postgresql.org/pgsql-committers/2008-02/msg00172.php Regards, Hiroshi Saito - Original Message - I have SQL Server 2005 that is linked to Postgresql 8.3.1-1 The following query does not work SELECT id FROM ALE

Re: [GENERAL] Linked server query problem

2008-12-04 Thread Richard Huxton
Anderson, Steven wrote: > I have SQL Server 2005 that is linked to Postgresql 8.3.1-1 Upgrade to the latest version in 8.3 at your soonest convenience. > The following query does not work > > SELECT id FROM ALERT.novastar.[public].[point] > > Error: > "SELECT "Tbl1002"."id" "Col1004" FROM "no

[GENERAL] Linked server query problem

2008-12-03 Thread Anderson, Steven
I have SQL Server 2005 that is linked to Postgresql 8.3.1-1 The following query does not work SELECT id FROM ALERT.novastar.[public].[point] Error: OLE DB provider "MSDASQL" for linked server "ALERT" returned message "ERROR: syntax error at or near ""Col1004""; Error while executing the