Re: type money causes unrestorable dump

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
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-05 00:44:44
Message-ID: 20071104194444.67352ca1.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 4 Nov 2007 17:24:10 -0500 (EST)
Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> 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.

Hmm. I think I like Tom's version better. However, since my primary
goal here is to remove the deprecation I will let you guys duke it out
over the additional clause. :-)

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-05 00:47:04 Re: should I worry?
Previous Message Neil Conway 2007-11-05 00:03:38 Re: "bad key in cancel request"