Re: [GENERAL] deadlocks in multiple-triggers environment

2005-06-09 Thread Alvaro Herrera
On Thu, Jun 09, 2005 at 04:26:44PM +0200, Csaba Nagy wrote: > [snip] > > Do say, are there foreign keys on those tables? > > > > If there are, that may explain the deadlocks. This is a known problem, > > fixed in the development version, for which there is no complete >

Re: [GENERAL] deadlocks in multiple-triggers environment

2005-06-09 Thread Csaba Nagy
[snip] > Do say, are there foreign keys on those tables? > > If there are, that may explain the deadlocks. This is a known problem, > fixed in the development version, for which there is no complete Wow, that's a good news :-) Time to drop that nasty patch we'r

Re: [GENERAL] deadlocks in multiple-triggers environment

2005-06-09 Thread Alvaro Herrera
On Wed, Jun 08, 2005 at 05:45:45PM +0200, hubert depesz lubaczewski wrote: > hi > i have a stituation a situation where i have multiple tables, and multiple > triggers on all of them. > at least 1 or 2 triggers on at lease 4 different tables does updates to main > cache table. Do say, are there