Thanks for the quick response.
But, if you already have many views created, and rather than going back
and recreating all of them, is there a setting in the for the driver that
can solve the problem?
I tried setting both
> ShowOidColumn = Yes
> FakeOidIndex = Yes
but I did not get any different results. Is that what these settings are
for? Am I doing something wrong with them?
Jeff Eckermann said:
> --- "George T. Gibson" <gtgibson@jbstamping.com>
> wrote:
>> I am trying to access PostgreSQL from Openoffice
>> using iodbc on Linux
>>
>> When trying to look at any views I get ERROR: column
>> "ctid" does not exist.
>>
>> Any suggestions?
>
> Every table contains a few system columns, including
> "ctid", which identifies the storage location of the
> record (IIRC). Normally these system columns are not
> visible when you list a tables columns, but you can
> select them.
>
> The PostgreSQL ODBC driver uses the "ctid" as a unique
> identifier for a record.
>
> AFAIK there is no reason why you could not just add
> "ctid" to your select list in your view definition.
>
> Note that using the ctid as an identifier in an
> application is not a good idea, as the ctid value for
> a particular record could change over time.
>