On Thu, 2023-05-11 at 20:02 -0400, Tom Lane wrote:
> What happens if somebody makes a user-defined collation in template0
> and then clones that into a different encoding?
I didn't know changing template0 was supported behavior for normal
operation.
> I guess the user-defined
> collation would then be hidden/inaccessible in the clone DB, so maybe
> it's
> fine.
Assuming we do support changes to template0, the fix would prevent
users from making a new ICU collation in template0 that is visible to
all encodings, other than calling pg_import_system_collations(). That
doesn't sound like a big problem; it's already impossible to do that
with libc collations.
Regards,
Jeff Davis