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.