Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Don't emit a spurious space at end of line in pg_dump of event triggers.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 2 Jul 2015 09:50:29 +0000 (12:50 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 2 Jul 2015 09:50:29 +0000 (12:50 +0300)
Backpatch to 9.3 and above, where event triggers were added.

src/bin/pg_dump/pg_dump.c

index 0a8129020bdda59682f88048922bf7bbbb83b8bc..32ac26f1db476cb34370ac82049d73f2575ef187 100644 (file)
@@ -15277,13 +15277,12 @@ dumpEventTrigger(Archive *fout, DumpOptions *dopt, 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 ");