[Info-ingres] Row locking

[Roy Hann]

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? 

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.

Roy