On 11/15/19 1:54 PM, John Lumby wrote:
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.
Not sure how that could be pulled off with Read Committed as it would
involve predicting the future from the POV of the transaction.
Cheers, John
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
