Re: PG odbc - MSQuery

From: "Jeroen van 't Hart" <J(dot)vantHart(at)arpa-intrabouw(dot)nl>
To: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PG odbc - MSQuery
Date: 2008-03-25 12:47:43
Message-ID: 3EA0C8E935E7A044B3FE6DCA33B52E623D6E3B@ARPA-SBS01.ai.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

>On Tue, Mar 25, 2008 at 1:48 AM, Jeroen van 't Hart
<J(dot)vantHart(at)arpa-intrabouw(dot)nl> wrote:
>
>> ERROR: cross-database references are not implemented:
>> "database.public.table"; Error while executing the query.

>Are you trying to join to tables from different databases?

No, in this example I'm accessing one database and I'm trying to view
one column from one table.

>> I also tried a newer and an older version (v 8.3.1 & v8.2.2) which
>> results in:
>> ERROR: relation "public.table" does not exist; Error while executing

>> the query.

>Most likely in this case your table is in a schema other than public.

I'm using only one schema, so unfortunately that isn't the problem

>--
>Regards,
>Richard Broersma Jr.

Browse pgsql-odbc by date

  From Date Subject
Next Message Roger Quincy 2008-03-25 14:03:07 Can't create DSN using SSPI authentication WinXP to WinXP
Previous Message Richard Broersma 2008-03-25 12:28:22 Re: PG odbc - MSQuery