check this node for a simillar case : https://groups.google.com/forum/#!searchin/comp.databases.ingres/$20Optimistic$20concurrency$20in$20a$20pesimmistic$20environment$20|sort:relevance/comp.databases.ingres/nsvpJcpMonA/51F_8szme6EJ