On Thursday, October 19, 2023, Wen Yi <wen-yi@xxxxxx> 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.