PGSQL读提交级别的事务实践

最新推荐文章于 2024-05-18 21:33:33 发布

FDU_LZM

最新推荐文章于 2024-05-18 21:33:33 发布

阅读量523

点赞数

文章标签： PGSQL 读已提交

本文链接：https://blog.csdn.net/FDU_LZM/article/details/103860298

版权

读提交级别下的实践

事务1	事务2
BEGIN
select *, xmin, xmax from time_test;
	update time_test set time = '1456' where id = 1;
select *, xmin, xmax from time_test;
	BEGIN;
	update time_test set time = '1457' where id = 1;
select *, xmin, xmax from time_test;
select *, xmin, xmax from time_test for update;	与事务2未提交的update冲突，导致两个事务回滚。