On Mon, 2026-11-16 at 13:00 +0100, Alexey Shishkin wrote:
> We can grab the text for problem description from 
> https://wiki.postgresql.org/wiki/Locale_data_changes
> 
> Regarding finding the affected indexes, ready SQL queries for various PG 
> versions are
> listed in the EDB KBA written by Peter Eisentraut.
> Or/and we can use amcheck as you suggested.
> 
> Also we should mention that not only indexes can be affected by locale 
> changes, but other objects
> like range-partitioned tables.
> 
> One more thing to stress is that locale changes can happen during the 
> lifecycle of the same major
> OS version, so any OS updates need to be verified for glibc changes.
> 
> Pls. let me know how you would like to proceed.

Sure.  You write a documentation patch, submit it to this list, and I am happy 
to
review it.

I suggest that the patch should not be too big.  Code samples and instructions 
for repair
would be too much in my opinion.  I'd say that the objective is to alert the 
reader to
the problem and tell him or her to rebuild affected indexes with REINDEX, and 
to use
amcheck to check if indexes are ok.

Yours,
Laurenz Albe


Reply via email to