postgres.git / summary / log / commit / refs

commit    0eaa49a5c4848f3f3fa5588dc58cb9af47779fb4
Author:   Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:     Thu Jul 02 09:50:29 2015 +0000
First released in: 9.6.0, 9.3.10, 9.4.5, 9.5.0

    Don't emit a spurious space at end of line in pg_dump of event triggers.
    
    Backpatch to 9.3 and above, where event triggers were added.


 src/bin/pg_dump/pg_dump.c | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 31b86bb315d..06ee202b37b 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -14680,13 +14680,12 @@ dumpEventTrigger(Archive *fout, EventTriggerInfo *evtinfo)
 	appendPQExpBufferStr(query, fmtId(evtinfo->dobj.name));
 	appendPQExpBufferStr(query, " ON ");
 	appendPQExpBufferStr(query, fmtId(evtinfo->evtevent));
-	appendPQExpBufferStr(query, " ");
 
 	if (strcmp("", evtinfo->evttags) != 0)
 	{
 		appendPQExpBufferStr(query, "\n         WHEN TAG IN (");
 		appendPQExpBufferStr(query, evtinfo->evttags);
-		appendPQExpBufferStr(query, ") ");
+		appendPQExpBufferChar(query, ')');
 	}
 
 	appendPQExpBufferStr(query, "\n   EXECUTE PROCEDURE ");


[parent: 505f78c446b0]