Re: Update - pg_dumpall money problem

Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> writes:
> I've done a pg_dumpall and then imported that to the new system but a
> copy is failing with the following:

> psql:/backups/eddie_pg_dumpall.sql:3076: ERROR: invalid input syntax
> for type money: "3.18"
> CONTEXT: COPY invoices, line 1, column net: "3.18"

> I asume that this is because 7.2 includes the currency sign, and 7.4
> doesn't like it.

No, money still expects a currency sign. It looks to me like the
problem is that the new database doesn't have the same monetary locale
as the old one, and so it doesn't think is the right currency
sign. You can fix this by changing the LC_MONETARY parameter.

regards, tom lane