ODBC Open cursors on views - Mailing list pgsql-odbc

From Shachar Shemesh
Subject ODBC Open cursors on views
Date
Msg-id 1060772327.3f3a19e7a647d@latenight.fiasco.org.il
Whole thread Raw
List pgsql-odbc
Hi all,

When trying to open a bidirectional cursor on a query that uses a view in the
from (i.e. - select * from "viewname"), the odbc driver returns an error
"Attribute ctid not found". The problem does not happen when I open a forward
only cursor.

It sounds to me like the ODBC driver uses the ctid in order to "find it's way
around". Views don't have that field, and hence the problem. Note: that
explanation was pure guesswork.

My questions are:
1. Is the above explanation correct?
2. Is this problem solveable through the ODBC driver?

       Many thanks,

            Shachar

pgsql-odbc by date:

Previous
From: Cyrille Chepelov
Date:
Subject: Re: of declare/fetch and strange HY010 errors (resolved)
Next
From: Andre Felipe Machado
Date:
Subject: app does not search for public schema qualifier