On Mon, 13 Jan 2003, Orr, Steve wrote:
> Finally, there are LOTS of deadlocks and I'm thinking it's because they are
> not doing "SELECT ... FOR UPDATE" or are explictly locking tables. Or they
> are constantly updating the same rows. It seems our duhvelopers need to get
Well, if you're using foreign keys, you might be running into a deficiency
in the foreign key implementation. If that is it, then currently a
partial workaround may be to make the constraints deferred which lessens
the length of the lock, but doesn't remove the base deadlock possibility.