Re: wCTE cannot be used to update parent inheritance table

On 29 January 2012 20:06, Josh Berkus <josh@agliodbs.com> wrote:
> On 1/28/12 5:27 PM, Tom Lane wrote:
>> Josh Berkus <josh@agliodbs.com> writes:
>>> SUMMARY: if you attempt to UPDATE or DELETE FROM a parent table in an
>>> inheritance relationship using a wCTE, you get the following error mess=
age:
>>> =A0 =A0 =A0ERROR: =A0could not find plan for CTE
>>
>> Fixed, thanks for the report.
>
> Should we add a regression test for this?

This is the kind of thing that could go unnoticed for a long time,
simply because it is not highlighted any more prominently than a
routine error message like an integrity constraint violation. I
continue to maintain that we should have a new severity level for this
sort of thing.

--=20
Peter Geoghegan =A0 =A0 =A0 http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services