On Monday, June 3, 2019 11:50:15 A.M. EDT Andres Freund wrote: > > This seems like an omission to me. Ideally, the presence of an > > explicit "NOT MATERIALIZED" clause on a data-modifying CTE should > > disable the "run to completion" logic. > > I don't see us ever doing that. The result of minor costing and other > planner changes would yield different updated data. That'll just > create endless bug reports.
I understand why the rule exists in the first place, but I think that an explicit opt-in signals the assumption of responsibility and opens the possibility of using this in a well-defined evaluation context, such as CASE WHEN. Elvis