Re: Server error and deadlocks

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.