Re: pg_dump and money type - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and money type
Date
Msg-id 28035.1189558769@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and money type  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: pg_dump and money type
List pgsql-hackers
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Tom Lane wrote:
>> This risk seems rather overstated, as it's unlikely that someone using
>> money would choose to reload their data into a DB with a fundamentally
>> incompatible locale setting.  

> It doesn't sound unlikely at all to me. For example, people often use
> C-locale for performance reasons, or because of ignorance of locale
> issues. One scenario that seems particularly likely is to initialize and
> load a database with en_US or C locale, and run like that for a few
> weeks. After that, you notice that something's wrong, strings are sorted
> in a funny way, etc. You realize that you're using the wrong locale, so
> you take a backup with pg_dump, re-initdb with correct locale, and restore.

If you're using type money, you will certainly have noticed whether it
spells the currency sign the way you like.  I can believe that someone
might go for a while with C where they should have used en_US, or vice
versa, but not that they'd have failed to notice the difference between
$ and DM, say.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Preparation for PostgreSQL releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump and money type