PostgreSQL Lock Conflicts

Database engineering course | @hnasr |

FORSHARE

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

The following commands acquire FORSHARE Row lock

  1. SELECT FOR SHARE

The following are row locks conflicting with FORSHARE

  1. FORNOKEYUPDATE
  2. FORUPDATE