Inconsistence in transaction isolation docs

From: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Inconsistence in transaction isolation docs
Date: 2007-10-16 11:18:55
Message-ID: 47149E1F.3040008@officinedigitali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

/From:
http://www.postgresql.org/docs/8.2/interactive/transaction-iso.html

"
Read Committed/ is the default isolation level in PostgreSQL. When a
transaction runs on this isolation level, a SELECT query sees only data
committed before the query began; it never sees either uncommitted data
or changes committed during query execution by concurrent transactions.
(However, the SELECT does see the effects of previous updates executed
within its own transaction, even though they are not yet committed.) In
effect, a SELECT query sees a snapshot of the database as of the instant
that that query begins to run. Notice that two successive SELECT
commands can see different data, even though they are within a single
transaction, if other transactions commit changes during execution of
the first SELECT.
"

to me the above sentence sounds inconsistent: it's asserting that both
1) and 2) apply:

1) it never sees ... changes committed during query execution by
concurrent transactions

2) Notice that two successive SELECT commands can see different data,
even though they
are within a single transaction, if other transactions commit changes
during execution
of the first SELECT

Can anyone explain, please?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sualeh Fatehi 2007-10-16 11:53:00 Re: pg_dump - schema diff compatibility
Previous Message Pavel Stehule 2007-10-16 10:56:47 Re: 8.3 beta problems