Re: transaction isolation

From: Kendall Willets <kendallwillets_at_yahoo.com>
Date: Tue, 30 Oct 2001 21:18:07 -0500
Message-ID: <ttu5cgef6g9lc9_at_news.supernews.com>


> My conclusion is that rows that are committed are not correctly shown in
> another session.
>
> Thanks in advance for any remarks,
>
> Ruud.
In a transaction, read consistency means that reading the same table twice will yield the same data each time (barring updates within the transaction of course).The session will hold the same snapshot of the data until the transaction ends via a commit or an abort, which may occur when the server runs out of space to hold the snapshot. Received on Wed Oct 31 2001 - 03:18:07 CET

Original text of this message