My question about the transaction

Wen Yi <wen-yi@qq.com>

From: Wen Yi <wen-yi@qq.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2023-10-19T11:36:26Z
Lists: pgsql-general
Hi community,
I am learning the transaction of the postgresql, and I try to test using these:


######



terminal 1:



postgres=# select * from t;
&nbsp;number 
--------
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
(1 row)

postgres=# update t set number = 2;
UPDATE 1
postgres=# select * from t;
&nbsp;number 
--------
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2
(1 row)

postgres=# select * from t;
&nbsp;number 
--------
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2
(1 row)

postgres=# 



######


terminal 2:


postgres=# create table t (number integer);
CREATE TABLE
postgres=# insert into t values (1);
INSERT 0 1
postgres=# begin;
BEGIN
postgres=*# insert into t values (2);
INSERT 0 1
postgres=*# select * from t;
&nbsp;number 
--------
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2
(2 rows)

postgres=*# rollback;
ROLLBACK



My question is, in my view, the transaction model should make sure that when one on-process transaction don't commit itself, the data on this transaction shouldn't can be modified by other transaction(I the single-statement also be treated as a simple transaction), but why the update works?(I think terminal 1 will block until the terminal 2's transaction commit or rollback).
Can someone share you opinion to me?
Thanks in advance!


Yours,
Wen Yi