Re: postgres ODBC problem with view

Ocke Janssen <[email protected]> Wed, 13 Oct 2010 08:04:06 +0200
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
Sorry for the duplicates. But it is working again ;-)

-oj

On 10/13/10 08:01, Ocke Janssen wrote:
> 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
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>