diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-12-29 21:16:15 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-12-29 21:16:15 +0200 |
| commit | a671d9409bfeac9ec5a622d74519fd1142a47274 (patch) | |
| tree | c3864a6d620a97d462407a8350cb0fbf07d33e3a /src | |
| parent | 66843265eed40d181066f408f0d35e7ac639eb96 (diff) | |
| download | postgresql-a671d9409bfeac9ec5a622d74519fd1142a47274.tar.gz postgresql-a671d9409bfeac9ec5a622d74519fd1142a47274.zip | |
pg_dump: Dump user mappings ordered by user name
This is to get a deterministic dump order independent of the order in
which the user mappings were created.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index c06d229d507..eefd7aa0637 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -11766,7 +11766,8 @@ dumpUserMappings(Archive *fout, "FROM pg_options_to_table(umoptions)" "), ', ') AS umoptions " "FROM pg_user_mappings " - "WHERE srvid = '%u'", + "WHERE srvid = '%u' " + "ORDER BY usename", catalogId.oid); res = PQexec(g_conn, query->data); |