PG odbc - MSQuery

I'm having trouble using the pg odbc driver (v. 8.2.5) in MS Query.
When I'm trying to select a column I get:
=20
ERROR: cross-database references are not implemented:
"database.public.table"; Error while executing the query.

I also tried a newer and an older version (v 8.3.1 & v8.2.2) which
results in:=20
ERROR: relation "public.table" does not exist; Error while executing the
query.
=20
In other applications everything works fine.
=20
Any idea's?
=20
Regards,=20
Jeroen vt H

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: PG odbc - MSQuery

On Tue, Mar 25, 2008 at 1:48 AM, Jeroen van 't Hart
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.

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: PG odbc - MSQuery

>On Tue, Mar 25, 2008 at 1:48 AM, Jeroen van 't Hart
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=20=
=20
>> 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.

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc