Bi-Directional Replication for PostgreSQL v1.0
So this might not be the right place for this, but i'm curious.How do people deal with "eventual consistency"?In my head once a transaction is done, it's everywhere and everyone has access to it.What happens if 2 nodes try to modify the same data at the same time? Or what happens if you insert on one node, then query on another before it propagates? And if the answer to those questions are what I think they are (that bad stuff happens), how do you setup your application to avoid doing it?