aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2005-05-11 18:07:14 +0000
committerBruce Momjian <bruce@momjian.us>2005-05-11 18:07:14 +0000
commitcc99c57e1e67bcee47b45d83834d09ce4488bee2 (patch)
tree5cfaa309063e59e8d7e3e275f75435c73925f35c
parentc5c1cc3bf864b9783231b5b214f22d7b662b360f (diff)
downloadpostgresql-cc99c57e1e67bcee47b45d83834d09ce4488bee2.tar.gz
postgresql-cc99c57e1e67bcee47b45d83834d09ce4488bee2.zip
a small tweak to enable display in the log file
of database name before table name when VACUUMing or ANALYZing a table. Cosimo Streppone
-rw-r--r--contrib/pg_autovacuum/pg_autovacuum.c6
1 files changed, 3 insertions, 3 deletions
diff --git a/contrib/pg_autovacuum/pg_autovacuum.c b/contrib/pg_autovacuum/pg_autovacuum.c
index d9cafa523dc..e44207e7edf 100644
--- a/contrib/pg_autovacuum/pg_autovacuum.c
+++ b/contrib/pg_autovacuum/pg_autovacuum.c
@@ -4,7 +4,7 @@
* Revisions by Christopher B. Browne, Liberty RMS
* Win32 Service code added by Dave Page
*
- * $PostgreSQL: pgsql/contrib/pg_autovacuum/pg_autovacuum.c,v 1.33 2005/05/11 17:57:56 momjian Exp $
+ * $PostgreSQL: pgsql/contrib/pg_autovacuum/pg_autovacuum.c,v 1.34 2005/05/11 18:07:14 momjian Exp $
*/
#include "postgres_fe.h"
@@ -1056,9 +1056,9 @@ perform_maintenance_command(db_info * dbi, tbl_info * tbl, int operation)
*/
if ((tbl->relisshared > 0 && strcmp("template1", dbi->dbname) != 0) ||
(operation == ANALYZE_ONLY))
- snprintf(buf, sizeof(buf), "ANALYZE %s", tbl->table_name);
+ snprintf(buf, sizeof(buf), "ANALYZE %s.%s", dbi->dbname, tbl->table_name);
else if (operation == VACUUM_ANALYZE)
- snprintf(buf, sizeof(buf), "VACUUM ANALYZE %s", tbl->table_name);
+ snprintf(buf, sizeof(buf), "VACUUM ANALYZE %s.%s", dbi->dbname, tbl->table_name);
else
return;