Re: pgsql-odbc bug querying VIEWs - Mailing list pgsql-odbc

From Hollysugar Webmaster
Subject Re: pgsql-odbc bug querying VIEWs
Date
Msg-id 001501c32b72$e0149fe0$a1d2a8c0@impsu.net
Whole thread Raw
In response to pgsql-odbc bug querying VIEWs  (Mahlon Stacy <mcs@mayo.edu>)
List pgsql-odbc
This issue is also a problem for us. We are also using views to provide
access to various users through ODBC. In addition to using select queries,
we are also using update and delete queries with rules to change the
underlying tables.

Any help would be appreciated.

Thanks.

Julie

<snip>
----- Original Message -----
From: "Mahlon Stacy" <mcs@mayo.edu>
To: <pgsql-odbc@postgresql.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
>
</snip>


pgsql-odbc by date:

Previous
From: Corrado Cavallini
Date:
Subject: Re: ODBC 07.03.0100 Incorrect mapping of Int8 fields in Ac
Next
From: Jeff Eckermann
Date:
Subject: Re: [INTERFACES] cannot insert zero in to numeric field