Re: pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Jeff Davis <jdavis(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.
Date: 2023-06-16 20:14:52
Message-ID: 770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2023-06-16 22:06:09 Re: pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.
Previous Message Jeff Davis 2023-06-16 17:41:49 pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.