Re: [HACKERS] pg_dump and money type

2007-09-11 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Since the money type has a locale dependent input and output format, there has to be some context saved when a database dump is created. For example, if your environment uses a locale that uses the opposite point-vs-comma conventions from

Re: [HACKERS] pg_dump and money type

2007-09-11 Thread Heikki Linnakangas
Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Since the money type has a locale dependent input and output format, there has to be some context saved when a database dump is created. For example, if your environment uses a locale that uses the opposite point-vs-comma

Re: [HACKERS] pg_dump and money type

2007-09-11 Thread Tom Lane
Heikki Linnakangas [EMAIL PROTECTED] 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,

Re: [HACKERS] pg_dump and money type

2007-09-11 Thread Alvaro Herrera
Tom Lane wrote: Heikki Linnakangas [EMAIL PROTECTED] 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