On Wed, Aug 21, 2019 at 9:30 AM Alex <zhihui.fan1...@gmail.com> wrote:
> > first issue "set default_transaction_isolation to 'serializable';" on the > both sessions, then run: > > Session 1: begin; select * from t; (2 rows selected); > Session 2: delete from t; (committed automatically) > Session 1: commit; (commit successfully). > > looks the reads in session 1 has no impact on the session 2 at all which > is conflicted with the document > This behavior makes sense to me. The effect can be considered as we execute the two sessions in a serial order of first session 1 and then session 2. Thanks Richard