Re: [GENERAL] Consistency of distributed transactions

2011-06-01 Thread Pete Chown
Craig Ringer wrote: Distributed transactions will give you atomicity if done right - with two-phase commit (2PC) - but AFAIK will *NOT* give you consistency across the databases in question. That's useful to know -- thanks. At least now I know my idea won't work, so I can forget about it and

[GENERAL] Consistency of distributed transactions

2011-05-31 Thread Pete Chown
Hello, I am interested in creating a system where Java EE distributed transactions would work with multiple Postgres databases. I'm having some difficulty understanding the transaction isolation guarantees that I would get from this configuration. Can I make my distributed transactions SERI