PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

RowShareLock

The RowShareLock lock is a Table lock. This list shows the commands that acquire RowShareLock and what locks conflicts with it.

The following commands acquire RowShareLock Table lock

  1. SELECT FOR UPDATE
  2. SELECT FOR SHARE
  3. SELECT FOR NO KEY UPDATE
  4. SELECT FOR KEY SHARE

The following are table locks conflicting with RowShareLock

  1. ExclusiveLock
  2. AccessExclusiveLock