The point of the locking was to block a race:

   delete from x where y in (select y from x)

The select runs first, then the delete, and if there's an insert between the two, the delete may fail.

I'll look at the suggested patch when I'm back home tonight.

Arnt

Reply via email to