Re: ADJACENT KEY LOCKING
Posted in 1995
Tony Tyrwhitt-Drake — — source: Informix-list mailing list archive (1991-1998)
In article <437hr0$2gj@nezsdc.fujitsu.co.nz>, steve@nezsdc.fujitsu.co.nz (Steve Chell) says: >What you say agrees with the documentation, however it does not >appear to work that way in practise. Perhaps I didn't explain it fully. Adjacent key locking happens only after a delete. The Insert does not need to lock anything except itself and so does not lock an adjacent key. The insert checks the adjacent keys in case they have been locked by a delete, but it only checks them. Does this make it any clearer, :-> ? Version 6 onwards does it completely differently, allegedly