>> b. Optimistic locking + write skew check: if the key is
modified by
>> another tx between 2) and 5), the entire transaction has to be redone
>
> might work as well, since people opted in for "optimistic" they should
> be prepared to experience failures.
> I'm not sure what the "+" stands for, how can you have optimistic
> locking without write skew checks?
writeSkewCheck can be disabled
Of course, but then I wouldn't call it optimistic anymore. It's more
of "damn sure, I'll overwrite the world!" mode.