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

From Tatsuo Ishii
Subject Re: Backpatch FK changes to 7.3 and 7.2?
Date
Msg-id 20030408.103750.108739130.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Backpatch FK changes to 7.3 and 7.2?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Backpatch FK changes to 7.3 and 7.2?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
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...

Me too!
--
Tatsuo Ishii



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Backpatch FK changes to 7.3 and 7.2?
Next
From: Stephan Szabo
Date:
Subject: Re: Backpatch FK changes to 7.3 and 7.2?