PostgreSQL Lock Conflicts
Database engineering course
|
@hnasr
|
☕
RowExclusiveLock
The RowExclusiveLock lock is a Table lock. This list shows the commands that acquire RowExclusiveLock and what locks conflicts with it.
The following commands acquire RowExclusiveLock Table lock
INSERT
UPDATE (NO KEYS)
UPDATE (KEYS)
DELETE
COPY FROM
MERGE
The following are table locks conflicting with RowExclusiveLock
ShareLock
ShareRowExclusiveLock
ExclusiveLock
AccessExclusiveLock