postgres.git / summary / log / commit / refs

commit    7b156c1e0746a46d083d7dbcd28afb303b3484ef
Author:   Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:     Thu Jul 02 09:50:29 2015 +0000

    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 0a8129020bd..32ac26f1db4 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -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 ");


[parent: f92d6a540ac4]