G
gus bjorklund
Guest
> On May 3, 2018, at 6:36 AM, George Potemkin wrote: > > Should ASSIGN statement upgrade the lock to EXCLUSIVE as it does with SHARE lock? > > > no. this is not necessary. the point of the “limbo” lock state is to optimize the lock release in order to eliminate future database actions, especially in the case of tcp/ip clients. the client no longer knows the lock state or anything else about the record because the buffer has been released (disconnected). when you find it again, the database remembers the exclusive lock state but the client does not know.
Continue reading...
Continue reading...