> Thanks Fabrice, that will help a lot.
> In my applications the conflict was not a direct table conflict e.g.
> USER1 locks Table1 record that references Table2 via foreign key with a
> cascade update/delete enforced then
> USER2 tried to lock Table2 for update on the referenced record - result both
> users locked !
> Is this the same scenario in your case ?
> perhaps a simple test db could used to resolve if this is the issue !
Looks like a deadlock situation not seen by the deadlock
detection code. Unfortunately I'm not able to reproduce a
lockup with a simple test DB. Could you post a simple
(trans1 does ..., trans2 does ...) sample so we coule
reproduce such a lockup?
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
In response to
pgsql-hackers by date
|Next:||From: Henry B. Hotz||Date: 2000-07-26 21:20:11|
|Subject: Re: Installation Report for powerpc-apple-netbsdelf1.5|
|Previous:||From: Jan Wieck||Date: 2000-07-26 19:17:15|
|Subject: Re: Some questions on user defined types and functions.|
pgsql-general by date
|Next:||From: Timothy H. Keitt||Date: 2000-07-26 19:57:33|
|Subject: adding column constraint|
|Previous:||From: Ulf Mehlig||Date: 2000-07-26 19:46:31|
|Subject: "alter table rename" does not update constraints|