Re: NT + deadlock intended behaviour ?

On Sun, Jul 18, 2004 at 11:00:25AM +0200, Gaetano Mendola wrote:
> Alvaro Herrera wrote:

> >If I abort only the innermost transaction on session 2, the application
> >writer can have a retry loop on it, so it will issue the "begin" again
> >and the same update.  Since session 1 is still locked, session 2 will
> >see a deadlock again.  The user could cope with detecting a deadlock
> >condition and do something else, but frankly I don't think we can leave
> >this as is.
> 
> I understand your point but I don't like the solution of invalidate the 
> whole transaction tree ( I don't know the good one ).

FYI, this is all moot with savepoints because we don't allow to create a
savepoint in an aborted transaction block.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sudor es la mejor cura para un pensamiento enfermo" (Bardia)