"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> 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?
The added text needs some copy-editing, I think. How about
Since the output of this data type is locale-sensitive, it may not work to load <type>money</> data into a
databasethat has a different setting of <varname>lc_monetary</>. To avoid problems, before restoring a dump make
sure<varname>lc_monetary</> has the same value as in the database that was dumped.
(Actually, the first of the two lc_monetary references should be
an xref link to the GUC variable, but I'm too lazy to type that out.)
A more direct approach to the problem might be to change pg_dump to
set lc_monetary, as it does for client_encoding ...
regards, tom lane