Re: ODBC with Visio

Steven Saner <ssaner(at)pantheranet(dot)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