Re: wCTE cannot be used to update parent inheritance table

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: wCTE cannot be used to update parent inheritance table
Дата
Msg-id CAEYLb_UHPgHN38cNjgYuQJnacspS7edAhOWcf4Nghu0Q-8S7pQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: wCTE cannot be used to update parent inheritance table  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: wCTE cannot be used to update parent inheritance table  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: wCTE cannot be used to update parent inheritance table
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: wCTE cannot be used to update parent inheritance table