Thread: LC_COLLATE is visible in the documentation for PostgreSQL 17, but it is not supported

LC_COLLATE is visible in the documentation for PostgreSQL 17, but it is not supported

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/sql-show.html
Description:

On the docs page for SHOW
(https://www.postgresql.org/docs/17/sql-show.html), LC_COLLATE is listed as
a parameter which can be shown, but trying to run SHOW LC_COLLATE on PG 17
results in the following:

ERROR: unrecognized configuration parameter "lc_collate"

And according to Laurenz it has been removed in PostgreSQL 16 already:
https://stackoverflow.com/a/77979710/2323727

I've never contributed to the docs, but I'm open to making the change if
needed (I just need to figure out how, first).

Thanks for the great docs
Ian

On Sat, Jan 4, 2025 at 11:53 PM PG Doc comments form
<noreply@postgresql.org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/sql-show.html
> Description:
>
> On the docs page for SHOW
> (https://www.postgresql.org/docs/17/sql-show.html), LC_COLLATE is listed as
> a parameter which can be shown, but trying to run SHOW LC_COLLATE on PG 17

i think, it was fixed in 2024-Dec-07 at
https://git.postgresql.org/cgit/postgresql.git/commit/?h=REL_17_STABLE&id=ad485171c703915b09a9f498fad69e89f75c9568

https://www.postgresql.org/docs/17/sql-show.html will be updated in
the next minor release, I think.