Re: ODBC Open cursors on views - Mailing list pgsql-odbc

From Shachar Shemesh
Subject Re: ODBC Open cursors on views
Date
Msg-id 1061201029.3f40a4851b5a8@latenight.fiasco.org.il
Whole thread Raw
In response to Re: ODBC Open cursors on views  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-odbc
Quoting Hiroshi Inoue <Inoue@tpf.co.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

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC Open cursors on views
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC Open cursors on views