Re: ODBC Open cursors on views

Quoting Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>:

> Shachar Shemesh wrote:
> >
> > 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.
>
> Is the bidirectional cursor read-only ?
>
> regards,
> Hiroshi Inoue
> http://www.geocities.jp/inocchichichi/psqlodbc/
>

I tried it both ways - neither worked.

This is a company I'm helping to add a backend to postgresql (they currently
support Oracle, MSsql and Access). They occasionally also do updates on views
(rare), so I guess that would come at some stage as well.

Shachar