Re: Some 8.4 changes needed according to pg_migrator testing

Peter Eisentraut <peter_e@gmx.net> writes:
> On Thursday 07 May 2009 20:54:37 Alvaro Herrera wrote:
>> I don't think there's much we can do apart from telling the user not to
>> move stuff across platforms that do not have equally named locales.

> The other part of the problem is that there is no guarantee that equally or 
> similarly named locales behave the same.  There will necessarily be a user-
> beware factor here, and perhaps blowing up when the locale name is not 
> recognized is safer and alerts about this fact better than trying to make it 
> match by force somehow.

We have never before operated on the assumption that it's okay for
pg_dump output to be locked to particular platforms, and I do not think
we should start now.  So we've got to do *something* about this.
(Do you really want PG Windows users to be unable to port to a better
platform?)

I note also that the problem is in pg_dumpall not pg_dump, so pg_restore
is not going to help us --- if someone has a problem his only recourse
would be manual editing of a possibly-monstrous SQL script file.
        regards, tom lane