headers
JUNG, Christian | 7 Dec 2011 18:00

Updateable Cursors with current PostgreSQL versions

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

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 1 comment |
headers
Inoue, Hiroshi | 8 Dec 2011 00:53
Picon

Re: Updateable Cursors with current PostgreSQL versions

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
>

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
(Continue reading)

Permalink | Reply | 0 comments |
headers
Hiroshi Saito | 30 Dec 2011 16:32
Picon

psqlODBC 09.01.0100 Released

We are pleased to announce the release of psqlODBC 09.01.0100. For
details of the changes in this release, please see the notes at:
http://psqlodbc.projects.postgresql.org/release.html

With this release two versions of the driver are provided for Windows;
'PostgreSQL ANSI' which supports single and multibyte applications
through the ANSI ODBC API, and 'PostgreSQL Unicode' which provides
Unicode support through the Unicode ODBC API. Microsoft's Distributed
Transaction Coordinator (MSDTC) is also supported.

On Unix systems, the driver type (ANSI or Unicode) may be selected
via a configure option. It can be compiled with UnixODBC or iODBC.

A new 64 bit version of the driver is also available for Windows, and
includes native SSPI and GSSAPI support, and doesn't require libpq.

psqlODBC may be downloaded from
http://www.postgresql.org/ftp/odbc/versions/ in source, Windows
Installer, merge module, and basic zip file formats.

Please post any bug reports to the pgsql-odbc <at> postgresql.org mailing list.

I'd like to take this opportunity to thank all those involved with the
development, testing and bug fixing of the updated driver.

-- 
psqlODBC team.

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
(Continue reading)

Permalink | Reply | 4 comments |

Gmane