Horton
Menu

pg_dump_readonly_xact.patch

application/octet-stream

Download
Filename: pg_dump_readonly_xact.patch
Type: application/octet-stream
Part: 0
Message: Re: pg_dump transaction's read-only mode

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: unified
File+−
src/bin/pg_dump/pg_dump.c 3 2 
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 82330cb..375653b 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -618,11 +618,12 @@ main(int argc, char **argv)
 		else
 			ExecuteSqlStatement(fout,
 								"SET TRANSACTION ISOLATION LEVEL "
-								"REPEATABLE READ");
+								"REPEATABLE READ, READ ONLY");
 	}
 	else
 		ExecuteSqlStatement(fout,
-							"SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");
+							"SET TRANSACTION ISOLATION LEVEL "
+							"SERIALIZABLE, READ ONLY");
 
 	/* Select the appropriate subquery to convert user IDs to names */
 	if (fout->remoteVersion >= 80100)