ODBC Open cursors on views

Поиск
Список
Период
Сортировка
От Shachar Shemesh
Тема ODBC Open cursors on views
Дата
Msg-id 1060772327.3f3a19e7a647d@latenight.fiasco.org.il
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Cyrille Chepelov
Дата:
Сообщение: Re: of declare/fetch and strange HY010 errors (resolved)
Следующее
От: Andre Felipe Machado
Дата:
Сообщение: app does not search for public schema qualifier