doc: Remove LC_COLLATE and LC_CTYPE from SHOW command
Hi,
Since version 16, the read-only server settings lc_collate and lc_ctype
have been removed [1]https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0f6c437160db640d4ea3e49398ebc3ba39d1982. 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
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0f6c437160db640d4ea3e49398ebc3ba39d1982
Attachments:
v1-0001-doc-remove-LC_COLLATE-and-LC_CTYPE-from-SHOW-comm.patchtext/x-patch; charset=UTF-8; name=v1-0001-doc-remove-LC_COLLATE-and-LC_CTYPE-from-SHOW-comm.patchDownload
From 32575b9478ecff4dd27a7215f9d34e6eb2abf6d0 Mon Sep 17 00:00:00 2001
From: Pierre GIRAUD <pierre.giraud@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
On 04.12.24 09:53, Pierre Giraud wrote:
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.
Committed. Thanks for checking and for providing a well-formed patch.