Re: type money causes unrestorable dump - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: type money causes unrestorable dump
Date
Msg-id 200711032237.33281.peter_e@gmx.net
Whole thread Raw
In response to Re: type money causes unrestorable dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: type money causes unrestorable dump
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: should I worry?