=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster