From d68ccf536e950a07b5a7030bf609936fe65aab51 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 10 Sep 2011 16:39:02 -0400 Subject: Remove double-quoting of table names in clusterdb. BACKWARD COMPABILITY BREAKAGE. Remove double-quoting of index/table names in reindexdb. BACKWARD COMPABILITY BREAKAGE. Document thate user/database names are preserved with double-quoting by command-line tools like vacuumdb. --- src/bin/scripts/clusterdb.c | 2 +- src/bin/scripts/createlang.c | 1 + src/bin/scripts/droplang.c | 1 + src/bin/scripts/reindexdb.c | 4 ++-- 4 files changed, 5 insertions(+), 3 deletions(-) (limited to 'src') diff --git a/src/bin/scripts/clusterdb.c b/src/bin/scripts/clusterdb.c index f4c317ae149..3742091e2a4 100644 --- a/src/bin/scripts/clusterdb.c +++ b/src/bin/scripts/clusterdb.c @@ -177,7 +177,7 @@ cluster_one_database(const char *dbname, bool verbose, const char *table, if (verbose) appendPQExpBuffer(&sql, " VERBOSE"); if (table) - appendPQExpBuffer(&sql, " %s", fmtId(table)); + appendPQExpBuffer(&sql, " %s", table); appendPQExpBuffer(&sql, ";\n"); conn = connectDatabase(dbname, host, port, username, prompt_password, progname); diff --git a/src/bin/scripts/createlang.c b/src/bin/scripts/createlang.c index c2153db630e..2f667e864a5 100644 --- a/src/bin/scripts/createlang.c +++ b/src/bin/scripts/createlang.c @@ -164,6 +164,7 @@ main(int argc, char *argv[]) exit(1); } + /* lower case language name */ for (p = langname; *p; p++) if (*p >= 'A' && *p <= 'Z') *p += ('a' - 'A'); diff --git a/src/bin/scripts/droplang.c b/src/bin/scripts/droplang.c index 7fadee0d513..f136a760ff0 100644 --- a/src/bin/scripts/droplang.c +++ b/src/bin/scripts/droplang.c @@ -165,6 +165,7 @@ main(int argc, char *argv[]) exit(1); } + /* lower case language name */ for (p = langname; *p; p++) if (*p >= 'A' && *p <= 'Z') *p += ('a' - 'A'); diff --git a/src/bin/scripts/reindexdb.c b/src/bin/scripts/reindexdb.c index 53fff01a74b..caeed7511ee 100644 --- a/src/bin/scripts/reindexdb.c +++ b/src/bin/scripts/reindexdb.c @@ -223,9 +223,9 @@ reindex_one_database(const char *name, const char *dbname, const char *type, appendPQExpBuffer(&sql, "REINDEX"); if (strcmp(type, "TABLE") == 0) - appendPQExpBuffer(&sql, " TABLE %s", fmtId(name)); + appendPQExpBuffer(&sql, " TABLE %s", name); else if (strcmp(type, "INDEX") == 0) - appendPQExpBuffer(&sql, " INDEX %s", fmtId(name)); + appendPQExpBuffer(&sql, " INDEX %s", name); else if (strcmp(type, "DATABASE") == 0) appendPQExpBuffer(&sql, " DATABASE %s", fmtId(name)); appendPQExpBuffer(&sql, ";\n"); -- cgit v1.2.3