Tim Uckun wrote:
> pg_upgrade from 8.4 to 9.0 fails with the following error message.
>
> old and new cluster lc_collate values do not match
>
>
> on 8.4 show lc_collate outputs
> ------------
> en_NZ.utf8
> (1 row)
>
>
> on 9.0 it outputs
> ------------
> en_NZ.UTF8
> (1 row)
>
>
> So the difference seems to be in capitalization. Presumably they are the
> same collation with "different" names so it strikes me as odd that
> pg_upgrade would balk and refuse to upgrade the database.
>
> pg_upgrade should be able to tell that these are the same collations and go
> ahead with the upgrade.
>
> It also should give some indication of how to overcome the problem.
[ Moved to hackers list.]
Interesting. It can be easily fixed in the C code. Does anyone know of
an example where the case of the locale name is significant in
controlling the behavior?
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +