On 17.02.23 21:43, Jeff Davis wrote:
select row_number() over (order by nazev collate "cs-x-icu"), nazev
from obce
except select row_number() over (order by nazev collate "cs_CZ"),
nazev from obce;
returns a not empty set. So minimally for Czech collate, an index
rebuild is necessary
Yes, that's true of any locale change, provider change, or even
provider version change.
I'm confused. We are not going to try to change existing databases to a
different collation provider during pg_upgrade, are we?
