Dmitry Yemanov wrote:

> "Ann W. Harrison" <aharrison@...> wrote:
>>>> Read-committed mode violates the Isolation and Consistency
>>>> properties of transactions
>
> Formally, I disagree (see above).
>

OK, then let me restate my principle without reference to
the ACID acronym. A transaction should see a consistent
state of the database, subject only to the changes it makes
itself. Read-committed transactions - and repeatable-read
transactions as defined by the SQL standard - do not meet
that test.

Without that property, it is impossible to run a two-stage
report (e.g. one that includes percent of total) on a active
data.


Regards,


Ann