[HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
Hi all, 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.

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Tom Lane
Shachar Shemesh [EMAIL PROTECTED] 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

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] 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

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Tom Lane
Shachar Shemesh [EMAIL PROTECTED] writes: Am I to understand that psql's nativ cursors support bidirectional movements on views? That is good news, actually. They do. (Complex views, like joins, may not work real well before 7.4.) I suspect your real difficulty is that a view will not expose