Re: ADJACENT KEY LOCKING

Tony Tyrwhitt-Drake <tonytd@ttyrwhit.demon.co.uk> wrote: >On an insert, only a check is done to see if the adjacent key >is locked, but no adjacent key locking happens, it is not needed. >The actual row inserted is locked instead. What you say agrees with the documentation, however it does not appear to work that way in practise. If, when a row is inserted it is locked, why doesn't a subsequent insert (by another process) fail if it attempts to insert to the immediate *left* of the first insert? I would have thought the second insert would fail because it tests the right adjacent key (ie the first insert) for an exclusive lock. Steve -- ______________________________________________________________________________ Steve Chell steve@nezsdc.fujitsu.co.nz Fujitsu NZ Ltd, Auckland, New Zealand FAX: +64.9.3564851