pgsql: Don't copy datlocale from template unless provider matches.

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Don't copy datlocale from template unless provider matches.
Date: 2025-08-05 16:25:51
Message-ID: E1ujKU3-000tsO-16@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't copy datlocale from template unless provider matches.

During CREATE DATABASE, if changing the locale provider, require that
a new locale is specified rather than trying to reinterpret the
template's locale using the new provider.

This only affects the behavior when the template uses the builtin
provider and CREATE DATABASE specifies the ICU provider without
specifying the locale. Previously, that may have succeeded due to
loose validation by ICU, whereas now that will cause an error. Because
it can cause an error, backport only to unreleased versions.

Discussion: https://postgr.es/m/5038b33a6dc639009f4b3d43fa6ae0c5ba9e04f7.camel@j-davis.com
Backpatch-through: 18

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/06697909b6699052ed5a207f495206b685f09761

Modified Files
--------------
src/backend/commands/dbcommands.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Masahiko Sawada 2025-08-05 17:51:37 pgsql: Add backup_type column to pg_stat_progress_basebackup.
Previous Message Jeff Davis 2025-08-05 16:25:44 pgsql: Don't copy datlocale from template unless provider matches.