Craig James <craig_james(at)emolecules(dot)com> wrote:
> The sequence of operations goes like this (pseudo-code):
> The problem is that very occasionally the same ID will be issued
> twice. I don't see how this can be. Doesn't the "for update"
> guarantee that no other process can claim that same row?
I don't see a flaw in the pseudo-code (other than an apparent typo
on the insert). Can you show the actual code?
-Kevin