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 по дате отправления: