Hi Hamish.

I am not sure if I understood clearly your problem. If I did, you probably should use "WITH LOCK" clause.

Thanks Hugo, that might work. But as the row might not exist yet, I would have to lock the whole table, else the two inserts could still run simultaneously and conflict.


Hamish