Tom Lane wrote:
> =?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck@freenet.de> writes:
>
>>I investigated a little bit further and can be more precisely
>>about the whole thing. This (wrong) behaviour only occurs, if
>>the view has an order by clause.
>
>
> The bug is triggered by the combination of an inherited UPDATE target
> and an unflattenable sub-Query. I verified that it's been broken for
> as long as we've had such features :-(.
>
> I've applied the attached patch to 8.0.
Thank you!
> You could probably adapt it for
> 7.4, but I'm hesitant to put such a nontrivial change into a stable
> branch without a lot more testing.
It isn't that necessary for me, just wondered 'bout the
strange behaviour.
Sebastian