Received: from waffel.germanistik.uni-bonn.de (waffel.germanistik.uni-bonn.de [131.220.90.150]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4PDt6A12040 for ; Fri, 25 May 2001 09:55:06 -0400 (EDT) (envelope-from jtr@uni-bonn.de) Received: by waffel.germanistik.uni-bonn.de (Postfix, from userid 1000) id E7BE3131995; Fri, 25 May 2001 15:51:50 +0200 (CEST) To: pgsql-sql@postgresql.org Subject: Problems with pg_dump (on Debian i386) From: Joachim Trinkwitz Date: 25 May 2001 15:51:50 +0200 Message-ID: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de> Lines: 24 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Copyleft) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200105/271 X-Sequence-Number: 3099 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