From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: carl.witt@knime.com
Subject: ALTER DATABASE lacks documentation of REFRESH COLLATION VERSION
Date: Tue, 10 Jun 2025 08:32:40 +0000
Message-ID: <174954436017.789.17527208973511012295@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-alterdatabase.html
Description:
The documentation of ALTER DATABASE mentions four forms and then skips to
"The remaining forms change the session default for a run-time configuration
variable", omitting the documentation of the fifth form
```
ALTER DATABASE name REFRESH COLLATION VERSION
```
It would be useful to have more information on what that command does, which
permissions it requires, whether the database can be used during this
operation, etc.
This command is relatively important since after operating system updates,
collations will often mismatch, issuing an warning that asks the
administrator to run this command.
```WARNING: database "..." has a collation version mismatch
DETAIL: The database was created using collation version 2.35, but the
operating system provides version 2.39.
HINT: Rebuild all objects in this database that use the default collation
and run ALTER DATABASE stats REFRESH COLLATION VERSION, or build PostgreSQL
with the right library version.
```
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, carl.witt@knime.com
Subject: Re: ALTER DATABASE lacks documentation of REFRESH COLLATION VERSION
In-Reply-To: <174954436017.789.17527208973511012295@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox