Re: Updatable cursors - applications? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Updatable cursors - applications?
Date
Msg-id 45C01966.6060108@tpf.co.jp
Whole thread Raw
In response to Updatable cursors - applications?  (Dave Page <dpage@postgresql.org>)
Responses Re: Updatable cursors - applications?
List pgsql-odbc
Dave Page wrote:
> Does anyone know if there are any apps in existence that can be used as
> a good test of the updatable cursor functionality in the driver?
>
> Hiroshi; do you have a test app for this purpose?
>
> In case anyone is wondering about my recent obsession with updatable
> cursors, there is a patch from EnterpriseDB for PostgreSQL which offers
> some quite significant performance benefits, but it does change the way
> CTIDs work which the UC feature relies on.

The driver relies on the following.
1. TID scans i.e  SELECT/UPDATE/DELETE ... where CTID = ...
    are available.
2. The fucntions currtid(2) returns the latest tid  of the given tid.

Does the patch change the above behavior ?

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Please correct the psqlodbc-08_01_0200 version
Next
From: Andreas
Date:
Subject: Re: Please correct the psqlodbc-08_01_0200 version