Skip site navigation (1) Skip section navigation (2)

Re: Updateable Cursors with current PostgreSQL versions

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 (view raw or flat)
Thread:
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
>


In response to

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2011-12-30 15:32:24
Subject: psqlODBC 09.01.0100 Released
Previous:From: JUNG, ChristianDate: 2011-12-07 17:00:10
Subject: Updateable Cursors with current PostgreSQL versions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group