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

From Joshua D. Drake
Subject Re: type money causes unrestorable dump
Date
Msg-id 20071008194213.676eeb0f@scratch
Whole thread Raw
In response to Re: type money causes unrestorable dump  (Bruce Momjian <bruce@momjian.us>)
Responses Re: type money causes unrestorable dump
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Release Notes Overview
Next
From: Bruce Momjian
Date:
Subject: Re: type money causes unrestorable dump