diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-09-10 19:57:48 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-09-10 19:57:48 +0000 |
| commit | a72fce035d6cf31047b18e822fe0395f75528ce4 (patch) | |
| tree | c2dd15c44152c5dca0eb61b7e07e9e1768a406e1 /contrib | |
| parent | 573f4500a31365c81cfd9c89afab257bacf79a1b (diff) | |
| download | postgresql-a72fce035d6cf31047b18e822fe0395f75528ce4.tar.gz postgresql-a72fce035d6cf31047b18e822fe0395f75528ce4.zip | |
Add quotes to vacuum/analyze for upper/lowercase table names, per
Matthew T. O'Connor.
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/pg_autovacuum/pg_autovacuum.c | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/contrib/pg_autovacuum/pg_autovacuum.c b/contrib/pg_autovacuum/pg_autovacuum.c index 01d22dbc6b1..afa6561a20c 100644 --- a/contrib/pg_autovacuum/pg_autovacuum.c +++ b/contrib/pg_autovacuum/pg_autovacuum.c @@ -581,7 +581,7 @@ xid_wraparound_check(db_info * dbi) { PGresult *res = NULL; - res = send_query("vacuum", dbi); + res = send_query("VACUUM", dbi); /* FIXME: Perhaps should add a check for PQ_COMMAND_OK */ PQclear(res); return 1; @@ -733,7 +733,7 @@ check_stats_enabled(db_info * dbi) PGresult *res = NULL; int ret = 0; - res = send_query("show stats_row_level", dbi); + res = send_query("SHOW stats_row_level", dbi); ret = strcmp("on", PQgetvalue(res, 0, PQfnumber(res, "stats_row_level"))); PQclear(res); @@ -1082,7 +1082,7 @@ main(int argc, char *argv[]) */ if ((tbl->curr_vacuum_count - tbl->CountAtLastVacuum) >= tbl->vacuum_threshold) { - snprintf(buf, sizeof(buf), "vacuum analyze %s", tbl->table_name); + snprintf(buf, sizeof(buf), "VACUUM ANALYZE \"%s\"", tbl->table_name); if (args->debug >= 1) { sprintf(logbuffer, "Performing: %s", buf); @@ -1096,7 +1096,7 @@ main(int argc, char *argv[]) } else if ((tbl->curr_analyze_count - tbl->CountAtLastAnalyze) >= tbl->analyze_threshold) { - snprintf(buf, sizeof(buf), "analyze %s", tbl->table_name); + snprintf(buf, sizeof(buf), "ANALYZE \"%s\"", tbl->table_name); if (args->debug >= 1) { sprintf(logbuffer, "Performing: %s", buf); |