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 "novastar"."public"."point" > "Tbl1002"" What's this supposed to do? Is "novastar" a database name? That's not going to work - you'll need to connect to "novastar" and select from "public.point". Are you using the MS-SQL "Linked Server" feature? I've never tried it with non-MS targets. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
