PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

FORUPDATE

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

The following commands acquire FORUPDATE Row lock

  1. SELECT FOR UPDATE
  2. UPDATE (KEYS)
  3. DELETE
  4. COPY FROM
  5. MERGE

The following are row locks conflicting with FORUPDATE

  1. FORKEYSHARE
  2. FORSHARE
  3. FORNOKEYUPDATE
  4. FORUPDATE