Re: Question about using ICU

2020-09-28 Thread Paul Förster
Hi Laurenz, > On 28. Sep, 2020, at 13:13, Laurenz Albe wrote: >> >> but then I'd have to do a reindex anyway, right? My goal was to avoid the >> reindex altogether, if possible. > > That couldn't be avoided anyway if you change the collation no matter > if you do it on the database or on the c

Re: Question about using ICU

2020-09-28 Thread Laurenz Albe
On Mon, 2020-09-28 at 11:45 +0200, Paul Förster wrote: > > 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.

Re: Question about using ICU

2020-09-28 Thread Paul Förster
Hi Laurenz, > On 28. Sep, 2020, at 11:04, Laurenz Albe 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

Re: Question about using ICU

2020-09-28 Thread Laurenz Albe
On Mon, 2020-09-28 at 10:02 +0200, Paul Förster wrote: > I have a general question about the use of ICU. Currently, we have PostgreSQL > compiled > from source (Linux) without ICU support. All database clusters and databases > are UTF8 > and of course relying on glibc. > > With the sooner or l

Question about using ICU

2020-09-28 Thread Paul Förster
Hi, I have a general question about the use of ICU. Currently, we have PostgreSQL compiled from source (Linux) without ICU support. All database clusters and databases are UTF8 and of course relying on glibc. With the sooner or later upcoming glibc release 2.28, there will probably a big reind