Re: [GENERAL] deadlocks - sharelocks on transactions

2004-01-07 Thread Tom Lane
Tim McAuley <[EMAIL PROTECTED]> writes: > I have a stored procedure that is causing deadlocks when called multiple > times synchronously. The odd issue is that the deadlock seems to be > happening on different threads waiting for locks on transactions. What > exactly is this transaction lock? >

Re: [GENERAL] deadlocks - sharelocks on transactions

2004-01-07 Thread Stephan Szabo
On Wed, 7 Jan 2004, Tim McAuley wrote: > Hi, > > I have a stored procedure that is causing deadlocks when called multiple > times synchronously. The odd issue is that the deadlock seems to be > happening on different threads waiting for locks on transactions. What > exactly is this transaction lo

[GENERAL] deadlocks - sharelocks on transactions

2004-01-07 Thread Tim McAuley
Hi, I have a stored procedure that is causing deadlocks when called multiple times synchronously. The odd issue is that the deadlock seems to be happening on different threads waiting for locks on transactions. What exactly is this transaction lock? ERROR: deadlock detected DETAIL: Process 1