Re: type money causes unrestorable dump

On Mon, 8 Oct 2007 22:31:31 -0400 (EDT)
Bruce Momjian <bruce@momjian.us> wrote:

> Tom Lane wrote:
> > Alvaro Herrera <alvherre@commandprompt.com> writes:
> > > I noticed that if you create a dump on a database containing a
> > > money column and a certain locale, this dump is not restorable on
> > > a database with a different locale.
> >
> > We've been through this, no?  If money doesn't print that way,
> > there's no obvious reason to have the type at all.  Use numeric if
> > you don't want something with locale-specific behavior.
>
> Added to TODO:
>
> * MONEY dumps in a locale-specific format making it difficult to
>   restore to a system with a different locale

Considering money is deprecated, is this really needed?

Joshua D. Drake

>


--
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/