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 lock?
My first guess would be waiting on row level locks. Are you doing anything with FOR UPDATE or foreign keys? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
