Re: pgsql-odbc bug querying VIEWs - Possible Solution

Mahlon,

What I did to solve the problem was to include tablename.oid and
tablename.ctid from one of the tables (all the rows must be included from
that table if it is an outer join) in the view. In the corresponding table
on the desktop we included a column for oid and ctid, but we do not use the
values for anything. Using this solution the psqlodbc driver is able to
identify the rows and execute the queries.

Julie
----- Original Message -----
From: "Mahlon Stacy" <mcs(at)mayo(dot)edu>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, June 04, 2003 8:03 AM
Subject: [ODBC] pgsql-odbc bug querying VIEWs

> I have created a postgres VIEW for a user into a set of tables,
> and want to provide the user access from ODBC on Windows. The
> query into the VIEW fails, however, with the following message:
>
> Microsoft Query: Error: No such attribute as bdstatview.oid
>
> I am not requesting an explicit query on the OID. I am only requesting
> retrieval of the columns listed in the view.
>
> Queries into the other (real) tables in the same database work fine.
>
> pgsql-odbc version 7.02.00.05
> Postgresql version 7.3.2-1
> Windows OS XP Pro
> DB Server OS Red Hat Linux 8.0
>
> I have tried restricting the query to a small subset of the VIEW columns,
> same result. I have also turned on Fake OIDs in the ODBC config and re-run
> the query, same results.
>
> I cannot access the pgsql-odbc server this morning to see if there
> is a later version of the driver.
>
> -Mahlon
> -------------------------------------------------------------
> Mahlon Stacy Internet: mcs(at)mayo(dot)edu
> Mayo Foundation (507) 284-4558
> Medical Science Bldg 1-43 FAX (507) 284-1632
> Rochester, MN 55905
> -------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org