Adrian Klaver wrote :
>
> Seems you are looking for Serializable Isolation Level:
>
True , that would solve the race condition, but it is too drastic.
We need to run with Read Committed.
I am looking for a solution which does not alter the application or overall behaviour,
but just addresses detecting which predicates to apply in some way.
Cheers, John