Re: [GENERAL] deadlock detected errors

2006-09-04 Thread Tom Lane
Clarence Gardner <[EMAIL PROTECTED]> writes: > The difference I'm asking about is that my artificial ones always involve > waiting on a transaction, while the ones from the real application always > involve one transaction wait and one tuple wait. > The first question is, is there any significance

[GENERAL] deadlock detected errors

2006-09-04 Thread Clarence Gardner
I am trying to locate the source of some deadlocks that have started cropping up recently, with little success, and I have a question regarding the message that accompanies them. The message my application gets is like this: Process 244 waits for ShareLock on transaction 39523645; blocked by proc