From 4041808b5b70433206b37e1305c807c325b06713 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 15 May 2017 11:48:39 -0400 Subject: [PATCH] Fix bogus syntax for CREATE PUBLICATION commands emitted by pg_dump. Original coding was careless about where to insert commas. Masahiko Sawada Discussion: https://postgr.es/m/3427593a-61aa-b17e-64ef-383b7742d6d9@enterprisedb.com --- src/bin/pg_dump/pg_dump.c | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index b6794d06de..f7b28408b5 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -3491,20 +3491,20 @@ dumpPublication(Archive *fout, PublicationInfo *pubinfo) first = false; } - if (!first) - appendPQExpBufferStr(query, ", "); - if (pubinfo->pubupdate) { + if (!first) + appendPQExpBufferStr(query, ", "); + appendPQExpBufferStr(query, "update"); first = false; } - if (!first) - appendPQExpBufferStr(query, ", "); - if (pubinfo->pubdelete) { + if (!first) + appendPQExpBufferStr(query, ", "); + appendPQExpBufferStr(query, "delete"); first = false; } -- 2.40.0