Re: Question about using ICU - Mailing list pgsql-general

From Paul Förster
Subject Re: Question about using ICU
Date
Msg-id 665E1A78-2B80-44A6-98AD-3644F1FD5F49@gmail.com
Whole thread Raw
In response to Re: Question about using ICU  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Question about using ICU  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi Laurenz,

> On 28. Sep, 2020, at 11:04, Laurenz Albe <laurenz.albe@cybertec.at> 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


pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Question about using ICU
Next
From: Matthias Apitz
Date:
Subject: how to switch off: WARNING: psql major version 11, server major version 13