Re: bidirectional cursors on views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shachar Shemesh <psql(at)shemesh(dot)biz>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bidirectional cursors on views
Date: 2003-08-17 18:56:59
Message-ID: 19673.1061146619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Shachar Shemesh <psql(at)shemesh(dot)biz> writes:
> When I try to open (using MFC) a non-forward only cursor on a view (i.e.
> - select * from viewname), I get an error of "attribute ctid not found".
> There are some chances that this is an ODBC problem, but my research
> suggests that the dependancy on ctid is created by the database itself.

Your research is faulty --- it's an ODBC issue.

> Can anyone comment about this? Is this problem solveable?

You'd have better luck asking on pgsql-odbc, but my guess is that they
depend on ctid as a (crude) form of unique row identification.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2003-08-17 18:58:48 Re: DOMAIN NEED CAST ?
Previous Message Sean Chittenden 2003-08-17 18:36:08 Re: compile error on cvs tip