Re: postgres ODBC problem with view

Moin,

On 10/11/10 21:06, Frank Schönheit wrote:
> Hi Josh/Zoltan,
>
>>> The data content could not be loaded.
>>> SQL Status: 42703
>>> Error code: 7
>>> ERROR: column "ctid" does not exist;
>>
>> That's very odd. ctid is a system column; no driver should be accessing
>> it, for any reason.
>
> Ocke knows more about this, but I suspect the PQ driver might deliver
> that column's name as BestRowIdentifier, which might tempt our RowSet to
> use it in some kind of "SELECT * FROM<table>  WHERE ctid=?" statement
> (for re/fetching rows).
>
> Ocke?
The problem is that Postgres doesn't support updateable cursor for 
views. Already discussed in 2004 :-)

http://archives.postgresql.org/pgsql-odbc/2004-03/msg00045.php

Solution:
http://comments.gmane.org/gmane.comp.openoffice.dba.devel/3037



Best regards,

Ocke

>
> Ciao
> Frank