Peter Eisentraut <peter_e@gmx.net> wrote:
> Could someone describe concisely what behavior "snapshot" isolation
> provides that repeatable read does?
Phantom reads are not possible in snapshot isolation. They are
allowed to occur (though not required to occur) in repeatable read.
Note that in early versions of the SQL standard, this difference was
sufficient to qualify as serializable; but recent versions raised
the bar for serializable transactions.
-Kevin