pgsql: Don't copy datlocale from template unless provider matches. - Mailing list pgsql-committers

From Jeff Davis
Subject pgsql: Don't copy datlocale from template unless provider matches.
Date
Msg-id E1ujKU3-000tsO-16@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Jeff Davis
Date:
Subject: pgsql: Don't copy datlocale from template unless provider matches.
Next
From: Masahiko Sawada
Date:
Subject: pgsql: Add backup_type column to pg_stat_progress_basebackup.