David Rowley <dgrowle...@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