On 11/07/2014 08:15 AM, Simon Riggs wrote:
> How about we set lock level on each Foreign Key like this
>
> [USING LOCK [lock level]]
>
> level is one of
> KEY - [FOR KEY SHARE] - default
> ROW - [FOR SHARE]
> TABLE SHARE - [ ]
> TABLE EXCLUSIVE - [FOR TABLE EXCLUSIVE]
I like the idea and thinks it solves the problem in a pretty neat way,
but I do not see any practical need for other levels than the highest
and the lowest of those.
Andreas