Thread: AW: AW: timeout on lock feature

AW: AW: timeout on lock feature

From
Zeugswetter Andreas SB
Date:
> > I envisioned:
> 
> >     SET TIMEOUT TO 10;
> >     UPDATE tab SET col = 3;
> >     RESET TIMEOUT
> 
> > Can't we get that work work properly?  Let the timeout only 
> apply to the
> > 'tab' table and none of the others.
> 
> As Henryk has implemented it, it WON'T only apply to the 'tab' table;
> it'll affect all locks grabbed anywhere, including those that the system
> locks internally.  That scares the heck out of me, Andreas' objections
> notwithstanding.

What exactly scares you ? Surely the deadlock resolution should
handle the above decision to ABORT in the same way it currently does.
If not we have something to fix, no?

Of course this might rather be something to consider for 7.2 and not 7.1.1.

Andreas