pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joachim Trinkwitz <jtr@uni-bonn.de>
To: pgsql-sql@postgresql.org
Subject: Problems with pg_dump (on Debian i386)
Date: 25 May 2001 15:51:50 +0200
Message-ID: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de> (raw)

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



view thread (4+ messages)  latest in thread

Message-ID: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de>
Permalink:  ../87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de/
Also on:    postgresql.org/message-id/87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jtr@uni-bonn.de
  Subject: Re: Problems with pg_dump (on Debian i386)
  In-Reply-To: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de>
  References: <87vgmp5yfd.fsf@waffel.germanistik.uni-bonn.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox