Re: Question about isolation level documentation - Mailing list pgsql-general

From Elliot S
Subject Re: Question about isolation level documentation
Date
Msg-id 534458F8.8040401@gmail.com
Whole thread Raw
In response to Re: Question about isolation level documentation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
On 04/08/2014 04:09 PM, Alvaro Herrera wrote:
> Elliot S wrote:
>> Is there a discussion somewhere regarding this line from the docs on
>> transaction isolation: "When you select the level Read Uncommitted
>> you really get Read Committed, and phantom reads are not possible in
>> the PostgreSQL implementation of Repeatable Read"? I get that RU is
>> the same as RC and why that is so, but why is RR mentioned in this
>> sentence and more importantly why does it claim phantom reads aren't
>> possible in RR despite the table above this paragraph clearly
>> stating they are? It looks like a documentation issue associated
>> with the true serialization mode introduced in 9.1.
> I read that as saying that even though the standard defines repeatable
> read as possibly having phantom reads, they don't occur in Postgres.
>
Oh - duh - that makes sense. Thanks. For some reason I couldn't make the
connection between the two clauses.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Question about isolation level documentation
Next
From: CS_DBA
Date:
Subject: check constraint question