Fix extended statistics with partial analyzes Either because of a previous ALTER TABLE .. SET STATISTICS 0 or because of being invoked with a partial column list, ANALYZE could fail to acquire sufficient data to build extended statistics. Previously, this would draw an ERROR and fail to collect any statistics at all (extended and regular). Change things so that we raise a WARNING instead, and remove a hint that was wrong in half the cases.
Reported by: David Rowley Discussion: https://postgr.es/m/CAKJS1f9Kk0NF6Fg7TA=juxsjps9kx6nvu27pb5qdcpoyavb...@mail.gmail.com Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/bf2a691e02d7766f185d9d8e0f092222a5c0a129 Modified Files -------------- src/backend/statistics/extended_stats.c | 83 +++++++++++++++++++++------------ src/test/regress/expected/stats_ext.out | 6 ++- src/test/regress/sql/stats_ext.sql | 2 + 3 files changed, 60 insertions(+), 31 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
