Re: wCTE cannot be used to update parent inheritance table - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: wCTE cannot be used to update parent inheritance table
Date
Msg-id CAEYLb_UHPgHN38cNjgYuQJnacspS7edAhOWcf4Nghu0Q-8S7pQ@mail.gmail.com
Whole thread Raw
In response to Re: wCTE cannot be used to update parent inheritance table  (Josh Berkus <josh@agliodbs.com>)
Responses Re: wCTE cannot be used to update parent inheritance table  (Josh Berkus <josh@agliodbs.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table
Next
From: Josh Berkus
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table