Re: pgsql-odbc bug querying VIEWs

From: "Hollysugar Webmaster" <webmaster(at)hollysugar(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: pgsql-odbc bug querying VIEWs
Date: 2003-06-05 14:58:07
Message-ID: 001501c32b72$e0149fe0$a1d2a8c0@impsu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>
</snip>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Jeff Eckermann 2003-06-06 23:47:19 Re: [INTERFACES] cannot insert zero in to numeric field
Previous Message George A.J 2003-06-05 03:20:54 cannot insert zero in to numeric field