Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> It has never been the case that there is a guarantee that a new
> operating system environment will have the same or more collations
> available as an earlier version. Even glibc removes or renames locales.
Indeed, and one of the alleged selling points of ICU was greater stability
of collation behaviors (including naming). I'd like to try to actually
achieve that.
> In this particular case, you can create user-defined collations to fill
> in the missing names if you want.
NO. YOU. CAN'T. At least not with convenient upgrade methods like
pg_upgrade. If the collation name isn't produced by the newer version's
initdb, pg_upgrade will fail.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs