SELECT FOR UPDATE

RU: SELECT FOR UPDATE

A PostgreSQL SELECT clause that acquires an exclusive row-level lock on each returned row, blocking other transactions from modifying or locking those rows until the current transaction commits. Used for pessimistic concurrency when a read must be followed by an update; prefer FOR NO KEY UPDATE when key columns are not changing to reduce contention.