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