直接update获取
最近更新时间: 2025-02-18 16:02:00
#session1
postgres=# begin;
BEGIN
postgres=# set lock_timeout to 1;
SET
postgres=# update t_row_lock set mc='postgres' where mc='pgxz';
UPDATE 1
postgres=#
#session2
postgres=# begin;
BEGIN
postgres=# set lock_timeout to 1;
SET
postgres=# update t_row_lock set mc='postgresql' where mc='TDSQL PG';
UPDATE 1
postgres=# 上面session1与session2分别持有mc=pgxz行和mc=TDSQL PG的行锁。