Re: Definition of REPEATABLE READ

2020-06-21 Thread Thomas Munro
to > be the correct definition of REPEATABLE READ. In response to that report, we added a paragraph to the manual to state explicitly that what we offer is snapshot isolation: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1575fbf1ac3c8464b2dade245deff537a3aa2498 https://w

Definition of REPEATABLE READ

2020-06-21 Thread Peter J. Holzer
I've read http://jepsen.io/analyses/postgresql-12.3 which reports a problem in PostgreSQL's SERIALIZABLE isolation leven (which has since been fixed) and also shows an example of a violation of what they consider to be the correct definition of REPEATABLE READ. Specifically: T1: