On Thursday, October 19, 2023, Wen Yi <wen-yi(at)qq(dot)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.