Re: Update Unicode data to Unicode 16.0.0
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Jeremy Schneider <schneider@ardentperf.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Nathan Bossart <nathandbossart@gmail.com>,
Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers
<pgsql-hackers@postgresql.org>
Date: 2025-03-17T17:31:44Z
Lists: pgsql-hackers
On Sat, 2025-03-15 at 18:23 -0700, Jeremy Schneider wrote: > Is the simple answer that functions & clauses related to both time > zones and character semantics should just all be considered STABLE > instead of IMMUTABLE? That was discussed a few times, but: (a) That doesn't exactly solve the problem, because people still need indexes on LOWER() or CASEFOLD(); and (b) If we change IMMUTABLE to mean "returns the same results on every platform for all time", that would be too strict for many purposes, like the planner doing constant folding. I have been thinking about ways we can express the right dependencies, and I may be making some proposals along those lines. Regards, Jeff Davis
Commits
-
pg_upgrade: Fix memory leak in check_for_unicode_update().
- de48056ec7d2 18.0 landed
-
pg_upgrade check for Unicode-dependent relations.
- b81ffa13e356 18.0 landed
-
Update Unicode data to Unicode 16.0.0
- 82a46cca99fa 18.0 landed