CREATE DATABASE: make LOCALE apply to all collation providers.
authorJeff Davis <jdavis@postgresql.org>
Fri, 16 Jun 2023 17:27:32 +0000 (10:27 -0700)
committerJeff Davis <jdavis@postgresql.org>
Fri, 16 Jun 2023 17:27:32 +0000 (10:27 -0700)
commita14e75eb0b6a73821e0d66c0d407372ec8376105
treeb0fd40e450cdb4f498f911b54a195dcd3ebd1a58
parentc0d951262c80f42b3bfe037f940e103a24da84f4
CREATE DATABASE: make LOCALE apply to all collation providers.

For CREATE DATABASE, make LOCALE parameter apply regardless of the
provider used. Also affects initdb and createdb --locale arguments.

Previously, LOCALE (and --locale) only affected the database default
collation when using the libc provider.

Discussion: https://postgr.es/m/1a63084d-221e-4075-619e-6b3e590f673e@enterprisedb.com
Reviewed-by: Peter Eisentraut
12 files changed:
doc/src/sgml/ref/create_collation.sgml
doc/src/sgml/ref/create_database.sgml
doc/src/sgml/ref/createdb.sgml
doc/src/sgml/ref/initdb.sgml
src/backend/commands/collationcmds.c
src/backend/commands/dbcommands.c
src/bin/initdb/initdb.c
src/bin/initdb/t/001_initdb.pl
src/bin/scripts/createdb.c
src/bin/scripts/t/020_createdb.pl
src/test/icu/t/010_database.pl
src/test/regress/expected/collate.icu.utf8.out