There are systems that get this right. Just apparently none for Postgres or MySQL :-(
There are remarkably few systems that get this right, and most of the few that remain (like Zookeeper) are key-value stores that don't support complex transactional semantics.