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