can't access views using psqlodbc_08_04_0200 - Mailing list pgsql-odbc

From Ben Carbery
Subject can't access views using psqlodbc_08_04_0200
Date
Msg-id AANLkTi=UJfVH6yScSEgK2cjjQxZ7c+5y_wkjO4Vc1sqX@mail.gmail.com
Whole thread Raw
List pgsql-odbc
I get a curios error when trying to access any view from my 8.4.4 database using Open Office Base and the psqlodbc_08_04_0200 driver. The error is that the column 'ctid' can't be found, but this column is not part of my schema. It might possibly be part of the underlying view implementation in postgres. I have no problems accessing actual tables.

I have posted a screenshot here showing the error and someone has posted a link to a previous and similar bug that implicated the ODBC driver: http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=34843.

Can anyone confirm if this is a driver issue?

cheers,

BC

pgsql-odbc by date:

Previous
From: Raiford@labware.com
Date:
Subject: Re: PostgreSQL ODBC 8.04.0200 and Crystal Reports XI Developer
Next
From: "Hiroshi Saito"
Date:
Subject: psqlODBC 09.00.0101 Released