From 8eb29194fc1711308804e8d4238a002a1cd35afe Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 31 Jul 2013 11:37:17 -0400 Subject: [PATCH] pg_dump/pg_dumpall: remove unnecessary SQL trailing semicolons Patch by Ian Lawrence Barwick --- src/bin/pg_dump/pg_dump.c | 1 - src/bin/pg_dump/pg_dumpall.c | 2 -- 2 files changed, 3 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 8beb5d152d2..e1ef55f69a8 100644 --- 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 12533073d81..615dd48f577 100644 --- 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)) -- 2.30.2