Inserting State Transitions in Postgres

Interesting. The way we handle STATUS/state machine storage in PG is via the status column that they don't like because of the lack of history. The way we keep history of states is with an audit_log via triggers, which we apply to basically every single table. It's not a true audit log that is outside of the DB, but for most other use cases(outside of a true audit capability), it works great.