PostgreSQL Lock Conflicts

FORNOKEYUPDATE

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

The following commands acquire FORNOKEYUPDATE Row lock

1. SELECT FOR NO KEY UPDATE
2. UPDATE (NO KEYS)

The following are row locks conflicting with FORNOKEYUPDATE

1. FORSHARE
2. FORNOKEYUPDATE
3. FORUPDATE