1. read-committed (default 级别)
客户端A:
epmdb=> start transaction ;
START TRANSACTION
epmdb=> update t1.dbversion set value =1200 where dbversionid=1;
UPDATE 1
epmdb=>
客户端B:
epmdb=> start transaction
epmdb-> ;
START TRANSACTION
epmdb=> select * from t1.dbversion ;
dbversionid | value | currentdataversion | targetdataversion
-------------+--------+--------------------+-------------------
1 | 110000 | 100 | 1
(1 row)
客户端A修改后,结果不变:
epmdb=> select * from t1.dbversion ;
dbversionid | value | currentdataversion | targetdataversion
-------------+--------+--------------------+-------------------
1 | 110000 | 100 | 1
A提交:
epmdb=> commit
epmdb-> ;
COMMIT
B查询:
epmdb=> select * from t1.dbversion ;
dbversionid | value | currentdataversion | targetdataversion
-------------+-------+--------------------+-------------------
1 | 1200 | 100 | 1
(1 row)
2. read-uncommited(Postgresql 不支持)
START TRANSACTION
epmdb=> set default_transaction_isolation