Home > mailing lists

Phantom read example for new Repeatable Read level - Mailing list pgsql-general

From	Durumdara
Subject	Phantom read example for new Repeatable Read level
Date	November 9, 2012 23:21:57
Msg-id	CAEcMXhnjOaie9LfWPDp2E7q_QLTvtYs1gQeVsdXkAk6Y91KyoA@mail.gmail.com Whole thread Raw
List	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

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

From: "George Weaver"
Date: 09 November 2012, 22:21:13
Subject: View using dblink fails if not able to make connection

From: "Kevin Grittner"
Date: 09 November 2012, 23:42:46
Subject: Re: Phantom read example for new Repeatable Read level