Re: Bug with updateable Views and inherited tables? - Mailing list pgsql-general

From Sebastian Böck
Subject Re: Bug with updateable Views and inherited tables?
Date
Msg-id 41610399.2040302@freenet.de
Whole thread Raw
In response to Re: Bug with updateable Views and inherited tables?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Random not so random
Next
From: Antonios Christofides
Date:
Subject: Is Win32 port good for operational use?