Glossary: PostgreSQL Beyond the Basics
Lost update
One transaction silently overwriting another's change. For example, two sales of Speckled Blue Mugs both write back a stale stock number. Fix it with `SET stock = stock - n` or `SELECT ... FOR UPDATE`.