Re: deadlocks in multiple-triggers environment - Mailing list pgsql-general

From Csaba Nagy
Subject Re: deadlocks in multiple-triggers environment
Date
Msg-id 1118327204.19612.155.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: deadlocks in multiple-triggers environment  (Alvaro Herrera <alvherre@surnet.cl>)
Responses Re: deadlocks in multiple-triggers environment  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-general
[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're using...
I'm not on the developers list, I guess it was discussed there, I'm
curios what kind of solution it is ? A special foreign key thing or row
level shared locks were implemented ?

[snip]

Cheers,
Csaba.



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: deadlocks in multiple-triggers environment
Next
From: "GIROIRE, Nicolas (COFRAMI)"
Date:
Subject: "returning" in postgresql request