Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group