Re: Foreign Key Deadlocking

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Steven Flatt <steven(dot)flatt(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Foreign Key Deadlocking
Date: 2007-04-18 15:36:37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

> Can someone confirm that I've identified the right fix?

I'm pretty sure that won't help you... see:

The deadlock will be there if you update/insert the child table and
update/insert the parent table in the same transaction (even if you
update some other field on the parent table than the key referenced by
the child table). If your transactions always update/insert only one of
those tables, it won't deadlock (assuming you order the inserts/updates
properly per PK).


In response to


Browse pgsql-performance by date

  From Date Subject
Next Message Craig A. James 2007-04-18 16:05:13 Re: Basic Q on superfluous primary keys
Previous Message Steven Flatt 2007-04-18 15:07:08 Foreign Key Deadlocking