On 11/29/2010 4:08 PM, Dimitry Sibiryakov wrote:

>
> Can't say about PG and MySQL, but Oracle doesn't just wait till commit, but in most
> cases also restart the statement after that. IMHO, it is quite unpleasant process,
> overcomplicated and AFAIK, Oracle has some bugs in this place.
>

With PG and InnoDB, the statement waits until the most
recent record version becomes available and then proceeds.
It's very simple and works well. Jim implemented it in
Falcon and NimbusDB.

Cheers,

Ann