Re: Inconsistence in transaction isolation docs

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
Subject: Re: Inconsistence in transaction isolation docs
Date: 2007-10-16 11:57:35
Message-ID: 200710161357.35988.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Dienstag, 16. Oktober 2007 schrieb Nico Sabbi:
> 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

What this is supposed to mean is that you don't see changes while your own
query runs.

>
> 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

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-10-16 12:08:16 Re: Inconsistence in transaction isolation docs
Previous Message Sualeh Fatehi 2007-10-16 11:53:00 Re: pg_dump - schema diff compatibility