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