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

From Tom Lane
Subject Re: wCTE cannot be used to update parent inheritance table
Date
Msg-id 11954.1327870405@sss.pgh.pa.us
Whole thread Raw
In response to Re: wCTE cannot be used to update parent inheritance table  (Josh Berkus <josh@agliodbs.com>)
List pgsql-bugs
Josh Berkus <josh@agliodbs.com> writes:
> 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 message:
>>> ERROR:  could not find plan for CTE

>> Fixed, thanks for the report.

> Should we add a regression test for this?

We did.  You could trouble to look at the commit before asking such
questions.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table
Next
From: Peter Geoghegan
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table