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
