ODBC Open cursors on views

From: Shachar Shemesh <psql(at)shemesh(dot)biz>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Open cursors on views
Date: 2003-08-13 10:58:47
Message-ID: 1060772327.3f3a19e7a647d@latenight.fiasco.org.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andre Felipe Machado 2003-08-13 20:33:56 app does not search for public schema qualifier
Previous Message Cyrille Chepelov 2003-08-12 09:29:09 Re: of declare/fetch and strange HY010 errors (resolved)