Re: type money causes unrestorable dump

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: type money causes unrestorable dump
Date: 2007-11-04 22:24:10
Message-ID: 200711042224.lA4MOAM26728@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

D'Arcy J.M. Cain wrote:
> + <para>
> + Since the output of this data type is locale-sensitive, it may not
> + work to load <type>money</> data into a database that has a different
> + setting of <varname>lc_monetary</>. To avoid problems, before
> + restoring a dump make sure <varname>lc_monetary</> has the same or
> + equivalent value as in the database that was dumped.
> + </para>
> +

How about:

> + restoring a dump make sure <varname>lc_monetary</> has a value similar
> + to the dumped database.

--
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. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-04 22:32:48 Re: [HACKERS] quote_literal with NULL
Previous Message Bruce Momjian 2007-11-04 21:58:08 Re: [HACKERS] Text <-> C string