Re: deadlocks in multiple-triggers environment

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: hubert depesz lubaczewski <depesz(at)gmail(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: deadlocks in multiple-triggers environment
Date: 2005-06-09 14:26:44
Message-ID: 1118327204.19612.155.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GIROIRE, Nicolas (COFRAMI) 2005-06-09 14:30:10 "returning" in postgresql request
Previous Message Alvaro Herrera 2005-06-09 14:17:22 Re: deadlocks in multiple-triggers environment