Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: wCTE cannot be used to update parent inheritance table
Date
Msg-id 4F25A6DF.8080506@agliodbs.com
Whole thread Raw
In response to Re: wCTE cannot be used to update parent inheritance table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: wCTE cannot be used to update parent inheritance table  (Peter Geoghegan <peter@2ndquadrant.com>)
Re: wCTE cannot be used to update parent inheritance table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-bugs by date:

Previous
From: Matteo Beccati
Date:
Subject: Re: BUG #6416: Expression index not used with UNION ALL queries
Next
From: Peter Geoghegan
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table