gpt4 book ai didi

postgresql - MERGE 语句的锁定级别

转载 作者:行者123 更新时间:2023-12-05 04:29:04 27 4
gpt4 key购买 nike

有谁知道 PostgreSQL 上的锁级别(行、表)是多少 MERGE命令?我试图深入研究文档,但找不到任何可以理清思路的内容。如果有人有线索并愿意分享,我们将不胜感激。

最佳答案

来自manual :

ROW EXCLUSIVE Conflicts with the SHARE, SHARE ROW EXCLUSIVE,EXCLUSIVE, and ACCESS EXCLUSIVE lock modes.

The commands UPDATE, DELETE, INSERT, and MERGE acquire this lock modeon the target table (in addition to ACCESS SHARE locks on any otherreferenced tables). In general, this lock mode will be acquired by anycommand that modifies data in a table.

关于postgresql - MERGE 语句的锁定级别,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/72437679/

27 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com