Execute SET TRANSACTION SNAPSHOT during pg_dump

simonat2ndQuadrant · simonat2ndQuadrant · commit b2ad82dafaae · 2013-05-06T15:37:17.000+01:00
Previous coding set the SQL buffer but never executed

Bug noted by me during beta testing
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
@@ -1034,6 +1034,7 @@ setup_connection(Archive *AH, const char *dumpencoding, char *use_role)
 
 			appendPQExpBuffer(query, "SET TRANSACTION SNAPSHOT ");
 			appendStringLiteralConn(query, AH->sync_snapshot_id, conn);
+			ExecuteSqlStatement(AH, query->data);
 			destroyPQExpBuffer(query);
 		}
 		else

Original file line number	Diff line number	Diff line change
`@@ -1034,6 +1034,7 @@ setup_connection(Archive AH, const char dumpencoding, char *use_role)`
`1034`	`1034`
`1035`	`1035`	`appendPQExpBuffer(query, "SET TRANSACTION SNAPSHOT ");`
`1036`	`1036`	`appendStringLiteralConn(query, AH->sync_snapshot_id, conn);`
	`1037`	`+ ExecuteSqlStatement(AH, query->data);`
`1037`	`1038`	`destroyPQExpBuffer(query);`
`1038`	`1039`	`}`
`1039`	`1040`	`else`