Re: ODBC with Visio - Mailing list pgsql-general

From Tom Lane
Subject Re: ODBC with Visio
Date
Msg-id 2138.981778717@sss.pgh.pa.us
Whole thread Raw
In response to ODBC with Visio  (Steven Saner <ssaner@pantheranet.com>)
List pgsql-general
Steven Saner <ssaner@pantheranet.com> writes:
> I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk with
> Postgres 7.0.2 on Linux 2.2.16 via the Win32 driver from Insight
> Distributions. The problem that I am having is that I get parse errors
> on all queries to the database. The reason is the rather "odd" way in
> which fields are specified in the query. In the psqlodbc log file I
> see things like:

> SELECT username.tablename.fieldname FROM username.tablename ...

> Where the username is the username that I connect to the database
> with, and tablename and fieldname are obvious. That generates a parse
> error from Postgres.

It looks like Visio (or maybe just Insight's driver) expects the
username to equate to a schema within the database.  We don't support
schemas yet, so I'm afraid you're stuck if you can't turn that off.

A hardwired assumption that user == schema seems pretty broken to me,
so with luck you will find there is a knob somewhere that you can
twiddle to affect this.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postmaster uses Large Amounts of Swap
Next
From: Guy Fraser
Date:
Subject: Re: Re: concatenate 2 numeric columns..