How about disabling the Updatable Cursors in the ODBC? I had a problem
with a view showing error message: Attribute "oid" not found until I
unchecked it.
"Juliet May"
<jmay@speark.c To: "Patrick Hatcher" <PHatcher@macys.com>
om> cc: <pgsql-novice@postgresql.org>,
<pgsql-novice-owner@postgresql.org>
04/16/2003 Subject: Re: [NOVICE] Hide column in a view?
09:38 AM
That option was already turned off. The problem is that views do not have
oids as system columns, yet the psqlodbc driver is looking for an oid
column
when it tries to access a view. In order to provide the psqlodbc driver
with
the oid column it was looking for we had to include the oid column in the
select statement in our definition of the view. Since it is now seen as a
user column the setting on the odbc panel does not affect it.
----- Original Message -----
From: "Patrick Hatcher" <PHatcher@macys.com>
To: <jmay@speark.com>
Cc: <pgsql-novice@postgresql.org>; <pgsql-novice-owner@postgresql.org>
Sent: Wednesday, April 16, 2003 9:53 AM
Subject: Re: [NOVICE] Hide column in a view?
>
> In ODBC, it's a setting. You can turn if off. Look click the Datasource
> button on your ODBC entry.