medium10 pts · first answer countstransactionsoptimistic-locking
Timestamp used as a version check
An app does optimistic locking with WHERE id = $1 AND updated_at = $2, where updated_at is set by app servers. Two edits sometimes overwrite each other. What is a likely cause?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator