Re: type money causes unrestorable dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: type money causes unrestorable dump
Date: 2007-10-04 19:30:24
Message-ID: 5500.1191526224@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-10-04 19:32:07 Re: First steps with 8.3 and autovacuum launcher
Previous Message Alvaro Herrera 2007-10-04 19:15:31 type money causes unrestorable dump