Thread: Updateable Cursors with current PostgreSQL versions

Hello,

the ODBC-driver has an option to emulate updateable cursors (default "on"). AFAIK are updateable cursors supported
sincePostgreSQL version 8.3. Does the driver have to emulate updateable cursors with current PostgreSQL-versions or
shouldthis 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

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
>