Re: Backpatch FK changes to 7.3 and 7.2? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Backpatch FK changes to 7.3 and 7.2?
Date
Msg-id 039b01c2fd6d$9f0b84b0$6500a8c0@fhp.internal
Whole thread Raw
In response to Backpatch FK changes to 7.3 and 7.2?  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Backpatch FK changes to 7.3 and 7.2?
List pgsql-hackers
> The changes I committed to address most of the FK deadlock problems
> reported can easily be applied to the 7.3 and 7.2 source trees as well.
> 
> Except for a slight change in the text of the error message that gets
> thrown "if one tries to delete a referenced PK for which a FK with ON
> DELETE SET DEFAULT exists" (it's a rare case, believe me), this patch
> would qualify for backpatching. The unnecessary FOR UPDATE lock of
> referenced rows could be counted as a bug.
> 
> Opinions?

Since I seem to suffer from these horrible deadlock problems all the time, I'd like it to be backported to 7.3...

Chris

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pg_trigger.tgtype question
Next
From: Tatsuo Ishii
Date:
Subject: Re: Backpatch FK changes to 7.3 and 7.2?