can't access views using psqlodbc_08_04_0200

From: Ben Carbery <ben(dot)carbery(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: can't access views using psqlodbc_08_04_0200
Date: 2010-10-09 23:52:41
Message-ID: AANLkTi=UJfVH6yScSEgK2cjjQxZ7c+5y_wkjO4Vc1sqX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2010-10-16 15:55:27 psqlODBC 09.00.0101 Released
Previous Message Raiford 2010-10-08 14:06:41 Re: PostgreSQL ODBC 8.04.0200 and Crystal Reports XI Developer