Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group