Hi,

I noticed an inaccuracy in the transaction isolation docs.  Under the 
Repeatable Read Isolation Level section it states:

“The Repeatable Read isolation level only sees data committed before the 
transaction began; it never sees either uncommitted data or changes committed 
during transaction execution by concurrent transactions.”

That is not entirely accurate.  The snapshot starts with the first SQL 
statement in the transaction, not at the start of the transaction.  Any change 
that is committed in another transaction after the start of the transaction but 
before the first SQL statement will be seen.

Brad.




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to