Subject Re: [IB-Architect] Isolation level implemetation
Author Helen Borrie
At 12:59 PM 20-12-00 +0200, you wrote:
> As I understand you want to be able to see record versions. Do you
> intend to
>see all of them? I think this only can have benefits in conjuction with
>transactions IDs and user or connection data for these transactions. And
>for sure
>such uncommited transactions must be read-only for every user but the most
> And what about the triggers, which are not in transaction content? Such a
>trigger can log all the database activity, not only commited.
>Ivan Prenosil wrote:
> > The reason why I would like to see Read Uncommitted isloation level
> > is to allow db administrator to see "who the hell is blocking that record
> > by updating it and is not about to commit/rollback the change !@#$% ?".
> > (just add before update trigger to store username into record)

I don't want to see dirty reads implemented for client transactions AT ALL.

To satisfy Ivan's very valid requirement, I'd like a function that's
surfaced in the Services API which reports uncommitted transactions, along
with their start times, the USER variable and any locks which currently
apply to each transaction. I guess this involves scanning the TIP or
deltas or something of that ilk...


All for Open and Open for All
InterBase Developer Initiative ยท