pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Davis <pgsql@j-davis.com>
To: Jeff Davis <jdavis@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.
Date: Fri, 16 Jun 2023 13:14:52 -0700
Message-ID: <770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com> (raw)
In-Reply-To: <E1qADSG-0026fm-Gd@gemulon.postgresql.org>
References: <E1qADSG-0026fm-Gd@gemulon.postgresql.org>

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&a...

https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=hippopotamus&dt=2023-06-16%2017%3A...

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






view thread (4+ messages)  latest in thread

Message-ID: <770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com>
Permalink:  ../770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com/
Also on:    postgresql.org/message-id/770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: pgsql@j-davis.com, jdavis@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: CREATE DATABASE: make LOCALE apply to all collation providers.
  In-Reply-To: <770040bf2ca4c247b2c88837a3cb00d2798cdde6.camel@j-davis.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox