Horton

Remove read-only server settings lc_collate and lc_ctype

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: b0f6c437160db640d4ea3e49398ebc3ba39d1982
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2023-06-07T14:57:06Z
Releases: 16.0 
Remove read-only server settings lc_collate and lc_ctype

The GUC settings lc_collate and lc_ctype are from a time when those
locale settings were cluster-global.  When those locale settings were
made per-database (PG 8.4), the settings were kept as read-only.  As
of PG 15, you can use ICU as the per-database locale provider, so
examining these settings is already less meaningful and possibly
confusing, since you need to look into pg_database to find out what is
really happening, and they would likely become fully obsolete in the
future anyway.

Reviewed-by: Jeff Davis <pgsql@j-davis.com>
Discussion: https://www.postgresql.org/message-id/696054d1-bc88-b6ab-129a-18b8bce6a6f0@enterprisedb.com

Files

PathChange+/−
contrib/citext/expected/citext_utf8_1.out modified +2 −2
contrib/citext/expected/citext_utf8.out modified +2 −2
contrib/citext/sql/citext_utf8.sql modified +2 −2
doc/src/sgml/config.sgml modified +0 −32
src/backend/utils/init/postinit.c modified +0 −4
src/backend/utils/misc/guc_tables.c modified +0 −26
src/test/regress/expected/collate.icu.utf8.out modified +2 −2
src/test/regress/expected/collate.linux.utf8.out modified +3 −3
src/test/regress/expected/collate.windows.win1252.out modified +3 −3
src/test/regress/sql/collate.icu.utf8.sql modified +2 −2
src/test/regress/sql/collate.linux.utf8.sql modified +3 −3
src/test/regress/sql/collate.windows.win1252.sql modified +3 −3

Documentation touched

Discussion