Re: [GENERAL] Is Pg 7.0.x's Locking Mechanism BROKEN?

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 !


Regards,
                Frank.