Problems with pg_dump (on Debian i386) - Mailing list pgsql-sql

From Joachim Trinkwitz
Subject Problems with pg_dump (on Debian i386)
Date
Msg-id 87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de
Whole thread Raw
Responses Re: Problems with pg_dump (on Debian i386)
List 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 by date:

Previous
From: "Mourad EL HADJ MIMOUNE"
Date:
Subject: INSERT value of type table
Next
From: Tom Lane
Date:
Subject: Re: Problems with pg_dump (on Debian i386)