Re: Serialization questions

On Wed, Aug 21, 2019 at 9:30 AM Alex <zhihui(dot)fan1213(at)gmail(dot)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