From 7a203a3f02c8b89ac76413103991a2eba363ca84 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 14 Nov 1999 17:27:01 +0000 Subject: [PATCH] Add recreate index notice to vacuum error. --- src/backend/commands/vacuum.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/backend/commands/vacuum.c b/src/backend/commands/vacuum.c index 0d631b15085..b7955e55535 100644 --- a/src/backend/commands/vacuum.c +++ b/src/backend/commands/vacuum.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/vacuum.c,v 1.123 1999/11/07 23:08:02 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/vacuum.c,v 1.124 1999/11/14 17:27:01 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1976,7 +1976,7 @@ vc_scanoneind(Relation indrel, int num_tuples) ru1.ru_utime.tv_sec - ru0.ru_utime.tv_sec); if (nitups != num_tuples) - elog(NOTICE, "Index %s: NUMBER OF INDEX' TUPLES (%u) IS NOT THE SAME AS HEAP' (%u)", + elog(NOTICE, "Index %s: NUMBER OF INDEX' TUPLES (%u) IS NOT THE SAME AS HEAP' (%u).\nTry recreating the index.", RelationGetRelationName(indrel), nitups, num_tuples); } /* vc_scanoneind */ @@ -2057,7 +2057,7 @@ vc_vaconeind(VPageList vpl, Relation indrel, int num_tuples, int keep_tuples) ru1.ru_utime.tv_sec - ru0.ru_utime.tv_sec); if (num_index_tuples != num_tuples + keep_tuples) - elog(NOTICE, "Index %s: NUMBER OF INDEX' TUPLES (%u) IS NOT THE SAME AS HEAP' (%u)", + elog(NOTICE, "Index %s: NUMBER OF INDEX' TUPLES (%u) IS NOT THE SAME AS HEAP' (%u).\nTry recreating the index.", RelationGetRelationName(indrel), num_index_tuples, num_tuples); } /* vc_vaconeind */ -- 2.47.2