Problems with pg_dump (on Debian i386)
| От | Joachim Trinkwitz |
|---|---|
| Тема | Problems with pg_dump (on Debian i386) |
| Дата | |
| Msg-id | 87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de обсуждение исходный текст |
| Ответы |
Re: Problems with pg_dump (on Debian i386)
|
| Список | pgsql-sql |
Dear all,
since some version hops, pg_dump created dump files won't be restored
correctly anymore here. In a table I have an array which holds data in
form of "x.y" values, where x are numbers and y either numbers or
letters. An example for a field including such an array is
{"1.2"}. After pg_dumping the DB, all values are OK, but when trying
to restore it, all characters after the x-value (that is, including
the dot) has vanished.
The same thing happens when I try to export the table via COPY TO and
then import again with COPY FROM: the export file is OK, but the
import fails.
This used to work in earlier versions.
Hoping for help,
joachim
-- Dr. Joachim Trinkwitz email: jtr@uni-bonn.de Germanistisches Seminar phone:
0228-737565
Rheinische Friedrich-Wilhelms-Universitaet fax: 0228-737479 Am Hof 1d, 53113 Bonn, Germany
В списке pgsql-sql по дате отправления: