LockMode

Locking strategy for concurrency control.

Index

Enumeration Members

• NONE
• OPTIMISTIC
• PESSIMISTIC_PARTIAL_READ
• PESSIMISTIC_PARTIAL_WRITE
• PESSIMISTIC_READ
• PESSIMISTIC_READ_OR_FAIL
• PESSIMISTIC_WRITE
• PESSIMISTIC_WRITE_OR_FAIL

Enumeration Members

NONE

NONE: 0

No locking.

OPTIMISTIC

OPTIMISTIC: 1

Optimistic locking via a version column.

PESSIMISTIC_PARTIAL_READ

PESSIMISTIC_PARTIAL_READ: 6

Pessimistic shared lock that skips already-locked rows (FOR SHARE SKIP LOCKED).

PESSIMISTIC_PARTIAL_WRITE

PESSIMISTIC_PARTIAL_WRITE: 4

Pessimistic exclusive lock that skips already-locked rows (FOR UPDATE SKIP LOCKED).

PESSIMISTIC_READ

PESSIMISTIC_READ: 2

Pessimistic shared lock (FOR SHARE).

PESSIMISTIC_READ_OR_FAIL

PESSIMISTIC_READ_OR_FAIL: 7

Pessimistic shared lock that fails immediately if the row is locked (FOR SHARE NOWAIT).

PESSIMISTIC_WRITE

PESSIMISTIC_WRITE: 3

Pessimistic exclusive lock (FOR UPDATE).

PESSIMISTIC_WRITE_OR_FAIL

PESSIMISTIC_WRITE_OR_FAIL: 5

Pessimistic exclusive lock that fails immediately if the row is locked (FOR UPDATE NOWAIT).