Re: [BUGS] BUG #6034: pg_upgrade fails when it should not.

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +