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

Re: PG odbc - MSQuery

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Jeroen van 't Hart" <J(dot)vantHart(at)arpa-intrabouw(dot)nl>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: PG odbc - MSQuery
Date: 2008-03-25 12:28:22
Message-ID: 396486430803250528n3277b308p2826fd2fc7242218@mail.gmail.com (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?


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

-- 
Regards,
Richard Broersma Jr.

In response to

pgsql-odbc by date

Next:From: Jeroen van 't HartDate: 2008-03-25 12:47:43
Subject: Re: PG odbc - MSQuery
Previous:From: Sebastian ReitenbachDate: 2008-03-25 11:49:52
Subject: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0

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