pg_dump/pg_dumpall: remove unnecessary SQL trailing semicolons

Patch by Ian Lawrence Barwick

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 8beb5d152d2ac57f78eab9bec69c2664d11be8ff..e1ef55f69a8af58b0af968f4bc64cb5ab8e8d383 100644 (file)
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -12761,7 +12761,6 @@ createViewAsClause(Archive *fout, TableInfo *tbinfo)
        appendPQExpBuffer(query, "SELECT definition AS viewdef "
                          "FROM pg_views WHERE viewname = ");
        appendStringLiteralAH(query, tbinfo->dobj.name, fout);
-       appendPQExpBuffer(query, ";");
    }
 
    res = ExecuteSqlQuery(fout, query->data, PGRES_TUPLES_OK);

diff --git a/src/bin/pg_dump/pg_dumpall.c b/src/bin/pg_dump/pg_dumpall.c
index 12533073d810894afef1afc8fa2431b3d5e894cd..615dd48f5771dc750d999bdf7c211d7778caeb09 100644 (file)
--- a/src/bin/pg_dump/pg_dumpall.c
+++ b/src/bin/pg_dump/pg_dumpall.c
@@ -1428,8 +1428,6 @@ dumpDatabaseConfig(PGconn *conn, const char *dbname)
        if (server_version >= 90000)
            appendPQExpBuffer(buf, ")");
 
-       appendPQExpBuffer(buf, ";");
-
        res = executeQuery(conn, buf->data);
        if (PQntuples(res) == 1 &&
            !PQgetisnull(res, 0, 0))