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

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 exa

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-comm

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

[HACKERS] pg_dump and money type

2007-09-11 Thread Peter Eisentraut
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 English (e.g., de_DE), then the following will fail to