| Lists: | pgsql-odbc |
|---|
| From: | "JUNG, Christian" <christian(dot)jung(at)shsservices(dot)org> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Updateable Cursors with current PostgreSQL versions |
| Date: | 2011-12-07 17:00:10 |
| Message-ID: | 24BB5F92CE3E62419C5A6D5B1A1E0F46065E9254@nts58.saarstahl.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
Hello,
the ODBC-driver has an option to emulate updateable cursors (default "on"). AFAIK are updateable cursors supported since PostgreSQL version 8.3. Does the driver have to emulate updateable cursors with current PostgreSQL-versions or should this option be disabled for newer PostgreSQL releases?
I tried to figur it out myself, but the code is very tricky on the whole configuration stuff... :-S
regards
Chris
--
phone: +49 6898/10-4987
web : www.shsservices.org
mail : Hofstattstraße 106a
D 66333 Voelklingen
| From: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | "JUNG, Christian" <christian(dot)jung(at)shsservices(dot)org> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Updateable Cursors with current PostgreSQL versions |
| Date: | 2011-12-07 23:53:51 |
| Message-ID: | 4EDFFC8F.4000102@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
Hi,
(2011/12/08 2:00), JUNG, Christian wrote:
> Hello,
>
> the ODBC-driver has an option to emulate updateable cursors (default "on").
＊Updatable Cursors* in psqlodbc means *updatable result set*. You can
call SQLSetPos(.., SQL_UPDATE/SQL_DELETE) or SQLBulkOperations() but
unfortunately psqlodbc driver doesn't support positioned update using
CURRENT OF CURSOR.
regards,
Hiroshi Inoue
> AFAIK are updateable cursors supported since PostgreSQL version 8.3.
Does the driver have to emulate updateable cursors with current
PostgreSQL-versions or should this option be disabled for newer
PostgreSQL releases?
>
> I tried to figur it out myself, but the code is very tricky on the whole configuration stuff... :-S
>
> regards
> Chris
>