| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: type money causes unrestorable dump |
| Date: | 2007-10-09 02:31:31 |
| Message-ID: | 200710090231.l992VVv19029@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)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
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-10-09 02:41:02 | Re: Release Notes Overview |
| Previous Message | Bruce Momjian | 2007-10-09 01:28:48 | Re: [HACKERS] Use of "postmaster" |