On Thursday, October 19, 2023, Wen Yi <wen...@qq.com> wrote: > Hi community, > I am learning the transaction of the postgresql, and I try to test using > these: >
You failed to show how the two sessions interleave. Also, your first session doesn’t use multi-statement transactions. postgres=# insert into t values (1); > INSERT 0 1 > postgres=# begin; > BEGIN > Session one can see this row and modify it just fine… David J.