Commita671d94

committed

pg_dump: Dump user mappings ordered by user name

This is to get a deterministic dump order independent of the order inwhich the user mappings were created.

1 parent6684326 commita671d94Copy full SHA for a671d94

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -11766,7 +11766,8 @@ dumpUserMappings(Archive *fout,`
`11766`	`11766`	`"FROM pg_options_to_table(umoptions)"`
`11767`	`11767`	`"), ', ') AS umoptions "`
`11768`	`11768`	`"FROM pg_user_mappings "`
`11769`		`-"WHERE srvid = '%u'",`
	`11769`	`+"WHERE srvid = '%u' "`
	`11770`	`+"ORDER BY usename",`
`11770`	`11771`	`catalogId.oid);`
`11771`	`11772`
`11772`	`11773`	`res=PQexec(g_conn,query->data);`

Comments

(0)