Re: Bug with updateable Views and inherited tables?

Tom Lane wrote:
> =?ISO-8859-1?Q?Sebastian_B=F6ck?= <sebastianboeck(at)freenet(dot)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