Horton

Re: [18] Policy on IMMUTABLE functions and Unicode updates

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Jeremy Schneider <schneider@ardentperf.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Daniel Verite <daniel@manitou-mail.org>, Jeff Davis <pgsql@j-davis.com>, Noah Misch <noah@leadboat.com>, Peter Eisentraut <peter@eisentraut.org>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2024-07-23T12:49:39Z
Lists: pgsql-hackers 
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’m not aware of any other RDBMS that updates Unicode versions in place; instead they support multiple Unicode versions and do 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