On Tue, 9 Oct 2007 13:16:08 -0400
"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote:
> On Tue, 9 Oct 2007 19:02:38 +0200
> Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > Am Dienstag, 9. Oktober 2007 schrieb D'Arcy J.M. Cain:
> > > + Due to locale changes this type may have problems with dump and
> > > + restore and care should be taken.
> >
> > With respect, this kind of advice is useless. What are the problems, when
> > do
> > they occur, and what should be done about them? We do know the answers to
> > all of these questions.
>
> Right. How about this:
>
> ...
> restore and care should be taken when dumping and reloading from
> different locales. To avoid problems always explicitely set your
> locale before both a dump and reload and make sure that they are
> identical.
I never received a response on this. Here is the full diff with the
above change. Since it is documentation and not code, is it OK to
commit this now?
Index: datatype.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v
retrieving revision 1.211
diff -u -p -u -r1.211 datatype.sgml
--- datatype.sgml 21 Oct 2007 20:04:37 -0000 1.211
+++ datatype.sgml 3 Nov 2007 12:03:55 -0000
@@ -834,14 +834,6 @@ ALTER SEQUENCE <replaceable class="param
<sect1 id="datatype-money">
<title>Monetary Types</title>
- <note>
- <para>
- The <type>money</type> type is deprecated. Use
- <type>numeric</type> or <type>decimal</type> instead, in
- combination with the <function>to_char</function> function.
- </para>
- </note>
-
<para>
The <type>money</type> type stores a currency amount with a fixed
fractional precision; see <xref
@@ -852,6 +844,15 @@ ALTER SEQUENCE <replaceable class="param
Output is generally in the latter form but depends on the locale.
</para>
+ <para>
+ Due to locale changes this type may have problems with dump and
+ restore and care should be taken when dumping and reloading from
+ different locales. To avoid problems always explicitely set your
+ locale before both a dump and reload and make sure that they are
+ identical.
+
+ </para>
+
<table id="datatype-money-table">
<title>Monetary Types</title>
<tgroup cols="4">
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]> | 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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
