rdb should abort write skews, lost updates, and phantoms properly since reader doesn't block writer's transaction and writer doesn't block reader's transaction. both mysql and postgresql have the problems in the implementation developer needs to understand.
A beginner's guide to the Write Skew anomaly, and how it differs between 2PL and MVCC - Vlad Mihalcea
