Subject Re: [IBO] Transaction question
Author Geoff Worboys
> My question now is, could a DEADLOCK appear in such a situation,
> when a user is only READING information from a readonly
> transaction ?

Not from that user. But presumably your system will support multiple
users, in which case a deadlock can still occur when updates from
multiple users conflict.

Oh, actually it can appear. If you use Isolation=tiConsistency on
either transaction you effectively prevent updates to all records that
it reads. For this reason Isolation=tiConsistency is not recommended
unless this is exactly what you want to happen.


Geoff Worboys
Telesis Computing