Phantom read example for new Repeatable Read level

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Phantom read example for new Repeatable Read level
Date: 2012-11-09 20:21:53
Message-ID: CAEcMXhnjOaie9LfWPDp2E7q_QLTvtYs1gQeVsdXkAk6Y91KyoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 them is in RR transaction.

What need to do in C1 to read C2's "phantom records"?
Can you show me the detailed steps?

Thanks for every info, help!

Best wishes: dd

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2012-11-09 20:42:39 Re: Phantom read example for new Repeatable Read level
Previous Message George Weaver 2012-11-09 19:21:22 View using dblink fails if not able to make connection