recall

← recall

row lock term

lock on a single row in a database

Default in Postgres for UPDATE — only the affected rows are locked. Other transactions can update other rows freely. Compare with table lock, which blocks everything.

topics: databases, locks, concurrency

references: