pgsql: Fix planner failure with extended statistics on partitioned tabl - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix planner failure with extended statistics on partitioned tabl
Date
Msg-id E1opw6C-001nuB-8S@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1f1865e9083625239769c26f68b9c2861b8d4b1c

Modified Files
--------------
src/backend/utils/adt/selfuncs.c        | 11 +++++++++--
src/test/regress/expected/stats_ext.out |  8 +++++++-
src/test/regress/sql/stats_ext.sql      |  3 ++-
3 files changed, 18 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: pg_stat_statements: fetch stmt location/length before it disappe
Next
From: Tom Lane
Date:
Subject: pgsql: Update time zone data files to tzdata release 2022f.