| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, "PostgreSQL development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Backpatch FK changes to 7.3 and 7.2? |
| Date: | 2003-04-08 01:24:37 |
| Message-ID: | 039b01c2fd6d$9f0b84b0$6500a8c0@fhp.internal |
| 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...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-04-08 01:29:33 | Re: Arrays ... need clarification.... |
| Previous Message | Richard Stover | 2003-04-08 00:39:34 | Re: vacuum by non-owner |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Peacetree | 2003-04-08 01:32:49 | Re: No merge sort? |
| Previous Message | Christopher Kings-Lynne | 2003-04-08 01:19:23 | Re: pg_trigger.tgtype question |