On Fri, 2023-06-16 at 17:41 +0000, Jeff Davis wrote: > CREATE DATABASE: make LOCALE apply to all collation providers.
This created a minor test diff for the test_extensions test for cs_CZ.UTF-8: https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=jay&dt=2023-06-16%2018%3A02%3A15&stg=testmodules-install-check-cs_CZ.UTF-8 https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=hippopotamus&dt=2023-06-16%2017%3A43%3A05&stg=testmodules-install-check-cs_CZ.UTF-8 I believe the new behavior is correct, and the test is being run incorrectly. The buildfarm members do an initdb with the cs_CZ locale, and then run the test_extensions test in installcheck mode against that installation. As expected that creates \dx+ output using the cs_CZ locale, which sorts "sequence" before "schema", unlike with the C locale. The test_extensions Makefile specifies NO_LOCALE=1 to avoid this kind of problem, but that doesn't help during an installcheck. Regards, Jeff Davis
