Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents
Date
Msg-id 3942702.1712726306@sss.pgh.pa.us
Whole thread Raw
In response to Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents
List 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 by date:

Previous
From: David Rowley
Date:
Subject: Re: Incorrect handling of IS [NOT] NULL quals on inheritance parents
Next
From: Heikki Linnakangas
Date:
Subject: Re: Improve eviction algorithm in ReorderBuffer