Hi Laurenz, > On 28. Sep, 2020, at 11:04, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > > There have been efforts to add this functionality: > https://www.postgresql.org/message-id/flat/5e756dd6-0e91-d778-96fd-b1bcb06c161a%402ndquadrant.com > but it didn't get done. seems to be a rather complex thing according to the thread. > Your best bet is to manually change the definition of all columns to use the new collation. > psql's \gexec may help. but then I'd have to do a reindex anyway, right? My goal was to avoid the reindex altogether, if possible. Cheers, Paul
