Re: type money causes unrestorable dump

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: type money causes unrestorable dump
Дата
Msg-id 200711032237.33281.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: type money causes unrestorable dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Doing it would be a problem
> when transporting dump files across platforms: what if the
> appropriate locale name is spelled differently on the new machine?

The question is which is more likely?

Using a dump on a similar platform with different locale settings is 
fairly common, especially by accident.  (And this is a problem that is 
easily masked if you don't run the restore with on-error-stop.)

Using a dump on a platform with different locale spellings is, in my 
mind, rarer.  And even then, if you have different locale spellings, 
chances are, you have semantically different locales configured.

What could help is if we could invoke this only if the money type is 
actually used.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: type money causes unrestorable dump
Следующее
От: ohp@pyrenet.fr
Дата:
Сообщение: Re: should I worry?