[Info-ingres] Row locking

[Mark]

On Fri, 27 Nov 2015 15:48:26 +0000 (UTC), Roy Hann
<specially at processed.almost.meat> wrote:

>Mark wrote:
>
>> I have an esqlc program which attempts to use row-level locking :
>
>[snip]
>
>> During the sleep I attempt to update a different record from another
>> session but it hangs as if the whole table is locked.  How can I get
>> row-level locking to work?
>
>Is the other session also using row-level locking? 

Yes.

>If it is using default (page-level) locking it can't acquire the
>exclusive page lock it requires and will wait, as you are seeing.

Good suggestion -- but that isn't it.