summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2013-07-31 15:37:17 +0000
committerBruce Momjian2013-07-31 15:37:17 +0000
commit8eb29194fc1711308804e8d4238a002a1cd35afe (patch)
tree06c035420a43311bc54921785f4fbb9984bfd3ac
parentd074b4e50d11768ab6da696b13d40ec05e4823fb (diff)
pg_dump/pg_dumpall: remove unnecessary SQL trailing semicolons
Patch by Ian Lawrence Barwick
-rw-r--r--src/bin/pg_dump/pg_dump.c1
-rw-r--r--src/bin/pg_dump/pg_dumpall.c2
2 files changed, 0 insertions, 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))