Re: Updatable cursors - applications?
| От | Hiroshi Inoue |
|---|---|
| Тема | Re: Updatable cursors - applications? |
| Дата | |
| Msg-id | 45C01966.6060108@tpf.co.jp обсуждение исходный текст |
| Ответ на | Updatable cursors - applications? (Dave Page <dpage@postgresql.org>) |
| Ответы |
Re: Updatable cursors - applications?
|
| Список | 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 по дате отправления: