Horton
Menu

Re: My question about the transaction

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Wen Yi <wen-yi@qq.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2023-10-19T14:59:08Z
Lists: pgsql-general 
On Thursday, October 19, 2023, Wen Yi <wen-yi@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.