Inserting State Transitions in Postgres

An append-only status model gives you full history, but concurrent transitions can produce contradictory records. Here’s how to prevent that.