diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-04-29 23:32:05 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-04-29 23:32:05 -0400 |
| commit | b7dc5da1969cb0756739feb393eea51a8265ca04 (patch) | |
| tree | cf13e72a32112490e1e7e4f90c17ea1c23303bf3 /src/test/modules/test_pg_dump/sql | |
| parent | 900d1144256a63250a2e326567b636ee3220b731 (diff) | |
Force COLLATE "C" to stabilize ordering, redux.
David Rowley correctly pointed out that I'd collat-ified only
one of the two troublesome queries. Definitely not my day.
Discussion: https://postgr.es/m/CAApHDvo8pMk5WWFAqwGzuQ-Xh+957W61io_OsCP0oUzqCCODTg@mail.gmail.com
Diffstat (limited to 'src/test/modules/test_pg_dump/sql')
| -rw-r--r-- | src/test/modules/test_pg_dump/sql/test_pg_dump.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/modules/test_pg_dump/sql/test_pg_dump.sql b/src/test/modules/test_pg_dump/sql/test_pg_dump.sql index de572adfedd..4598531ce7f 100644 --- a/src/test/modules/test_pg_dump/sql/test_pg_dump.sql +++ b/src/test/modules/test_pg_dump/sql/test_pg_dump.sql @@ -86,7 +86,7 @@ FROM (SELECT pg_describe_object(classoid,objoid,objsubid) COLLATE "C" AS obj, initprivs FROM pg_init_privs WHERE privtype = 'e' ORDER BY 1) s, aclexplode(s.initprivs) a; -SELECT pg_describe_object(classid,objid,objsubid) AS obj, +SELECT pg_describe_object(classid,objid,objsubid) COLLATE "C" AS obj, pg_describe_object(refclassid,refobjid,0) AS refobj, deptype FROM pg_shdepend JOIN pg_database d ON dbid = d.oid @@ -138,7 +138,7 @@ FROM (SELECT pg_describe_object(classoid,objoid,objsubid) COLLATE "C" AS obj, initprivs FROM pg_init_privs WHERE privtype = 'e' ORDER BY 1) s, aclexplode(s.initprivs) a; -SELECT pg_describe_object(classid,objid,objsubid) AS obj, +SELECT pg_describe_object(classid,objid,objsubid) COLLATE "C" AS obj, pg_describe_object(refclassid,refobjid,0) AS refobj, deptype FROM pg_shdepend JOIN pg_database d ON dbid = d.oid |