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

From Tom Lane
Subject Re: type money causes unrestorable dump
Date
Msg-id 5500.1191526224@sss.pgh.pa.us
Whole thread Raw
In response to type money causes unrestorable dump  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: type money causes unrestorable dump
Re: type money causes unrestorable dump
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: type money causes unrestorable dump
Next
From: Simon Riggs
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher