Re: Hide column in a view? - Mailing list pgsql-novice

From Juliet May
Subject Re: Hide column in a view?
Date
Msg-id 005801c30436$913635e0$a1d2a8c0@impsu.net
Whole thread Raw
In response to Re: Hide column in a view?  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: Hide column in a view?  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Novice needs help in Portuguese-BR
Next
From: "Patrick Hatcher"
Date:
Subject: Re: Hide column in a view?