postgres.git / summary / log / commit / refs

commit    adfc157dd91471e995f3aa72e0fb5b50ecd93575
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Jan 06 00:27:04 2015 +0000
First released in: 9.5.0, 9.3.6, 9.4.1

    Fix broken pg_dump code for dumping comments on event triggers.
    
    This never worked, I think.  Per report from Marc Munro.
    
    In passing, fix funny spacing in the COMMENT ON command as a result of
    excess space in the "label" string.


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

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 6658fda83e3..fc7a9ec9dba 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -15097,7 +15097,7 @@ dumpEventTrigger(Archive *fout, DumpOptions *dopt, EventTriggerInfo *evtinfo)
 		}
 		appendPQExpBufferStr(query, ";\n");
 	}
-	appendPQExpBuffer(labelq, "EVENT TRIGGER %s ",
+	appendPQExpBuffer(labelq, "EVENT TRIGGER %s",
 					  fmtId(evtinfo->dobj.name));
 
 	ArchiveEntry(fout, evtinfo->dobj.catId, evtinfo->dobj.dumpId,
@@ -15106,7 +15106,7 @@ dumpEventTrigger(Archive *fout, DumpOptions *dopt, EventTriggerInfo *evtinfo)
 				 query->data, "", NULL, NULL, 0, NULL, NULL);
 
 	dumpComment(fout, dopt, labelq->data,
-				NULL, NULL,
+				NULL, evtinfo->evtowner,
 				evtinfo->dobj.catId, 0, evtinfo->dobj.dumpId);
 
 	destroyPQExpBuffer(query);


[parent: 3c9e4cdbf2ec]