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.

Reply via email to