type money causes unrestorable dump

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
type money causes unrestorable dump
Дата
Msg-id
20071004191531.GC21453@alvh.no-ip.org
Список
Дерево обсуждения
type money causes unrestorable dump Alvaro Herrera <alvherre@commandprompt.com>
Re: type money causes unrestorable dump Tom Lane <tgl@sss.pgh.pa.us>
Re: type money causes unrestorable dump Alvaro Herrera <alvherre@commandprompt.com>
Re: type money causes unrestorable dump Bruce Momjian <bruce@momjian.us>
Re: type money causes unrestorable dump "Joshua D. Drake" <jd@commandprompt.com>
Re: type money causes unrestorable dump Bruce Momjian <bruce@momjian.us>
Re: type money causes unrestorable dump "Joshua D. Drake" <jd@commandprompt.com>
Re: type money causes unrestorable dump Bruce Momjian <bruce@momjian.us>
Re: type money causes unrestorable dump "Joshua D. Drake" <jd@commandprompt.com>
Re: type money causes unrestorable dump "Joshua D. Drake" <jd@commandprompt.com>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump "Joshua D. Drake" <jd@commandprompt.com>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Peter Eisentraut <peter_e@gmx.net>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Tom Lane <tgl@sss.pgh.pa.us>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Tom Lane <tgl@sss.pgh.pa.us>
Re: type money causes unrestorable dump Peter Eisentraut <peter_e@gmx.net>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Bruce Momjian <bruce@momjian.us>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Tom Lane <tgl@sss.pgh.pa.us>
Re: type money causes unrestorable dump "D'Arcy J.M. Cain" <darcy@druid.net>
Re: type money causes unrestorable dump Gregory Stark <stark@enterprisedb.com>
Re: type money causes unrestorable dump Gregory Stark <stark@enterprisedb.com>
Re: type money causes unrestorable dump Tom Lane <tgl@sss.pgh.pa.us>
I noticed that if you create a dump on a database containing a money
column and a certain locale, this dump is not restorable on a database
with a different locale.

Most notably, I tried dumping the regression database (which is created
with --locale=C), and then importing it into a database of my own
creation, which uses --locale=fr_CA.UTF-8.

Due to the thousands separator being different, the regression database
is not restorable on the french database.

The regression test uses for input the unadorned form:

insert into rtest_emp values ('wiech', '5000.00');

But on output, pg_dump uses the localized form:

COPY money (a) FROM stdin;
$7 000,00
\.

Surely pg_dump should be using the unadorned form as well?

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ