On 22.10.22 03:22, Thomas Munro wrote:
> I'd love to hear others' thoughts on how we can turn this into a
> workable solution. Hopefully while staying simple...
I played with this patch a bit. It looks like a reasonable approach.
Attached is a small patch to get the dynamic libicu* lookup working with
the library naming on macOS.
Instead of packing the ICU version into the locale field ('63:en'), I
would make it a separate field in pg_collation and a separate argument
in CREATE COLLATION.
At this point, perhaps it would be good to start building some tests to
demonstrate various upgrade scenarios and to ensure portability.