| From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Dave Page <dpage(at)postgresql(dot)org> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Updatable cursors - applications? |
| Date: | 2007-01-31 04:21:58 |
| Message-ID: | 45C01966.6060108@tpf.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas | 2007-01-31 05:15:00 | Re: Please correct the psqlodbc-08_01_0200 version |
| Previous Message | Hiroshi Inoue | 2007-01-31 04:15:14 | Re: Please correct the psqlodbc-08_01_0200 version |