Postgres Pro
Downloads
Home   >   mailing lists

Re: [18] Policy on IMMUTABLE functions and Unicode updates - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [18] Policy on IMMUTABLE functions and Unicode updates
Date
Msg-id CA+TgmoaUD=LPsc4F++kBXoFfkRFKOmFoTXkWoLfLww5P=4_ifg@mail.gmail.com
Whole thread Raw
In response to Re: [18] Policy on IMMUTABLE functions and Unicode updates  (Jeremy Schneider <schneider@ardentperf.com>)
Responses Re: [18] Policy on IMMUTABLE functions and Unicode updates
List pgsql-hackers
Tree view 
On Tue, Jul 23, 2024 at 8:32 AM Jeremy Schneider
<schneider@ardentperf.com> wrote:
> Other RDBMS are very careful not to corrupt databases, afaik including function based indexes, by changing Unicode.
I’mnot aware of any other RDBMS that updates Unicode versions in place; instead they support multiple Unicode versions
anddo not drop the old ones. 
>
> See also:
> https://www.postgresql.org/message-id/E8754F74-C65F-4A1A-826F-FD9F37599A2E%40ardentperf.com

Hmm. I think we might have some unique problems due to the fact that
we rely partly on the operating system behavior, partly on libicu, and
partly on our own internal tables.

--
Robert Haas
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Vacuum ERRORs out considering freezing dead tuples from before OldestXmin
Next
From: Amit Langote
Date:
Subject: Re: pgsql: Add more SQL/JSON constructor functions