Fix planner failure with extended statistics on partitioned tables.
Tom Lane <tgl@sss.pgh.pa.us>
Fix planner failure with extended statistics on partitioned tables. Some cases would result in "cache lookup failed for statistics object", due to trying to fetch inherited statistics when only non-inherited ones are available or vice versa. Richard Guo and Justin Pryzby Discussion: https://postgr.es/m/20221030170520.GM16921@telsasoft.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/selfuncs.c | modified | +9 −2 |
| src/test/regress/expected/stats_ext.out | modified | +7 −1 |
| src/test/regress/sql/stats_ext.sql | modified | +2 −1 |
Discussion
- pg15 inherited stats expressions: cache lookup failed for statistics object 8 messages · 2022-10-30 → 2022-11-02