On Wed, Nov 5, 2014 at 7:17 PM, Álvaro Hernández Tortosa <a...@8kdata.com> wrote: >>> Given a transaction started with "BEGIN.... (REPEATABLE READ | >>> SERIALIZABLE)", if a concurrent session commits some data before *any* >>> query >>> within the first transaction, that committed data is seen by the >>> transaction. This is not what I'd expect. >> >> I think the problem is with your expectation, not the behavior. > > But my expectation is derived from the documentation: > > "The Repeatable Read isolation level only sees data committed before the > transaction began;"
Yes, that's inaccurate. We should fix it. (But we should not change the behavior, because I'm pretty sure that the villagers would show up with pitchforks when various currently-harmless scenarios caused massive database bloat.) -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
