Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents
Дата
Msg-id 3942702.1712726306@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:
> I think a better fix is just to not apply the optimisation for
> inheritance RTEs in add_base_clause_to_rel().

Is it worth paying attention to whether the constraint is marked
connoinherit?  If that involves an extra syscache fetch, I'd tend to
agree that it's not worth it; but if we can get that info for free
it seems worthwhile to not break this for inheritance cases.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Improve eviction algorithm in ReorderBuffer