Hi,
Since version 16, the read-only server settings lc_collate and lc_ctype
have been removed [1]. Unfortunately, the documentation has been updated
only partially.
Attached is a patch to also update the page for the "SHOW" SQL command
and remove the corresponding "LC_COLLATE" and "LC_CTYPE" parameters. I
successfully built the doc in HTML locally.
This patch has been created against the current master branch but it
should equally be applied to REL_16_STABLE and REL_17_STABLE.
Thanks,
Pierre
[1]
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0f6c437160db640d4ea3e49398ebc3ba39d1982
From 32575b9478ecff4dd27a7215f9d34e6eb2abf6d0 Mon Sep 17 00:00:00 2001
From: Pierre GIRAUD <pierre.gir...@dalibo.com>
Date: Wed, 4 Dec 2024 09:03:02 +0100
Subject: [PATCH v1] doc: remove LC_COLLATE and LC_CTYPE from SHOW command
The corresponding read-only server settings have been removed since
in PG16. See commit b0f6c437160db6.
---
doc/src/sgml/ref/show.sgml | 24 ------------------------
1 file changed, 24 deletions(-)
diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml
index b3747b119f..5fbb5bbe01 100644
--- a/doc/src/sgml/ref/show.sgml
+++ b/doc/src/sgml/ref/show.sgml
@@ -77,30 +77,6 @@ SHOW ALL
</listitem>
</varlistentry>
- <varlistentry>
- <term><literal>LC_COLLATE</literal></term>
- <listitem>
- <para>
- Shows the database's locale setting for collation (text
- ordering). At present, this parameter can be shown but not
- set, because the setting is determined at database creation
- time.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><literal>LC_CTYPE</literal></term>
- <listitem>
- <para>
- Shows the database's locale setting for character
- classification. At present, this parameter can be shown but
- not set, because the setting is determined at database creation
- time.
- </para>
- </listitem>
- </varlistentry>
-
<varlistentry>
<term><literal>IS_SUPERUSER</literal></term>
<listitem>
--
2.43.0
