can"t access views using psqlodbc_08_04_0200

can"t access views using psqlodbc_08_04_0200

am 10.10.2010 01:52:41 von ben.carbery

--00c09f972961a0b125049237d2f0
Content-Type: text/plain; charset=UTF-8

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

--00c09f972961a0b125049237d2f0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 tha=
t the column 'ctid' can't be found,=20
but this column is not part of my schema. It might possibly be part of=20
the underlying view implementation in postgres. I have no problems=20
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 imp=
licated the ODBC driver: forum/viewtopic.php?f=3D40&t=3D34843">http://user.servic es.openoffice.o=
rg/en/forum/viewtopic.php?f=3D40&t=3D34843
.


Can anyone confirm if this is a driver issue?

cheers,

BC<=
br>

--00c09f972961a0b125049237d2f0--