Re: mvcc.sgml make up - Mailing list pgsql-patches

From Tom Lane
Subject Re: mvcc.sgml make up
Date
Msg-id 1788.1133811552@sss.pgh.pa.us
Whole thread Raw
In response to Re: mvcc.sgml make up  (Volkan YAZICI <volkan.yazici@gmail.com>)
Responses Re: mvcc.sgml make up  (Volkan YAZICI <volkan.yazici@gmail.com>)
List pgsql-patches
Volkan YAZICI <volkan.yazici@gmail.com> writes:
> For the second mvcc.sgml edit, there's a huge difference between "two
> successive SELECT commands" and "two successive same SELECT commands".

Indeed, and I would argue that your proposed change is exactly wrong.
For instance,
    SELECT * FROM foo WHERE col > 4;
    SELECT * FROM foo WHERE col > 5;
Under READ COMMITTED, the second SELECT may retrieve rows not found by
the first, which would be impossible under SERIALIZABLE mode.

            regards, tom lane

pgsql-patches by date:

Previous
From: Dennis Bjorklund
Date:
Subject: I have a non-ascii name.
Next
From: Seneca Cunningham
Date:
Subject: AIX FAQ update