Re: [BUGS] ON DELETE SET NULL clauses do error when more than two columns are referenced to one table

2007-08-14 Thread Heikki Linnakangas
Tom Lane wrote: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: >> I'm not sure what to do about this. We could change the order the >> triggers are fired to breadth-first. If all the setnull triggers were >> executed first, there would be no problem. But that seems like a pretty >> big change, an

Re: [BUGS] ON DELETE SET NULL clauses do error when more than two columns are referenced to one table

2007-08-14 Thread Tom Lane
I wrote: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: >> I'm not sure what to do about this. We could change the order the >> triggers are fired to breadth-first. If all the setnull triggers were >> executed first, there would be no problem. But that seems like a pretty >> big change, and I'm a

Re: [BUGS] ON DELETE SET NULL clauses do error when more than two columns are referenced to one table

2007-08-14 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > I can take a stab at writing a patch. I beat you to it, barely. > Does this need to be backported? I think it does, seeing that it's a regression from 7.4. regards, tom lane ---(end of broadcast)--