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

Reply via email to