From 0f66d2120154e51960a21062b214d468782d8554 Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Sat, 15 Nov 2014 22:49:54 +0000 Subject: [PATCH] Emit msg re skipping ANALYZE for absent inh tree When checking a table that has an inheritance tree marked, if no child tables remain, we skip ANALYZE. This patch emits a message to show that the action has been skipped. Author: Etsuro Fujita Reviewer: Furuya Osamu --- src/backend/commands/analyze.c | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c index 954e5a68b6..732ab228cc 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -1483,6 +1483,10 @@ acquire_inherited_sample_rows(Relation onerel, int elevel, /* CCI because we already updated the pg_class row in this command */ CommandCounterIncrement(); SetRelationHasSubclass(RelationGetRelid(onerel), false); + ereport(elevel, + (errmsg("skipping analyze of \"%s.%s\" inheritance tree --- this inheritance tree contains no child tables", + get_namespace_name(RelationGetNamespace(onerel)), + RelationGetRelationName(onerel)))); return 0; } -- 2.40.0