Re: [GENERAL] Phantom read example for new Repeatable Read level

2012-11-09 Thread Kevin Grittner
Durumdara wrote: > What need to do in C1 to read C2's "phantom records"? After posting a reply I remembered another recent thread which was more-or-less on the same topic, but with a different slant. Perhaps you would also find that useful: http://archives.postgresql.org/pgsql-general/2012-11/ms

Re: [GENERAL] Phantom read example for new Repeatable Read level

2012-11-09 Thread Kevin Grittner
Durumdara wrote: > Can somebody show me an example for phantom read in "Repeatable > Read" mode (in 9.1, new, serialized kind of isolation level)? The repeatable read isolation level did not change in 9.1. Phantom reads were not possible in repeatable read transactions either before or after 9.1.

[GENERAL] Phantom read example for new Repeatable Read level

2012-11-09 Thread Durumdara
Dear Everybody! Can somebody show me an example for phantom read in "Repeatable Read" mode (in 9.1, new, serialized kind of isolation level)? The help wrote that it is possible: Repeatable read Not possible Not possible Possible But I don't understand, why, and how. C1, C2 are clients. Every of