Re: postgres ODBC problem with view

Ocke Janssen <[email protected]> Wed, 13 Oct 2010 07:46:20 +0200
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
  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).
I just groked for getBestRowIdentifier and it isn't used anywhere. So 
the problem is some where else. I'll take a look at it.

- oj
> Ocke?
>
> Ciao
> Frank