• Hmm, not sure I can explain this behaviour but how are you creating (and what it actually is) "index value"?

    If it is some number I suggest to use sequence instead of some max+1 or something like that. So you won't get duplicates. Of course enabled novalidated constraint should be used anyway to be absolutely sure that even manually new duplicates cannot be created.