| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | chriskl(at)familyhealth(dot)com(dot)au |
| Cc: | JanWieck(at)Yahoo(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Backpatch FK changes to 7.3 and 7.2? |
| Date: | 2003-04-08 01:37:50 |
| Message-ID: | 20030408.103750.108739130.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2003-04-08 01:39:34 | Re: vacuum by non-owner |
| Previous Message | Joe Conway | 2003-04-08 01:29:33 | Re: Arrays ... need clarification.... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian E. Pangburn | 2003-04-08 02:01:51 | A funny story about horology regression test failures... |
| Previous Message | Ron Peacetree | 2003-04-08 01:32:49 | Re: No merge sort? |