有谁知道 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 mode on the target table (in addition to ACCESS SHARE locks on any other referenced tables). In general, this lock mode will be acquired by any command that modifies data in a table.

https://stackoverflow.com/questions/72437679/