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