pg_dump trunc some rows

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump trunc some rows
Date: 2003-07-04 16:46:55
Message-ID: 003801c3424b$e1030dc0$152aa8c0@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
I have a DB ( postgres 7.3.3 ) with encoding SQL_ASCII and in
some field I have strange character:

# \encoding
SQL_ASCII
# select city, id_country from user_data where id_user = 4146;
city | id_country
---------------------------+------------
Serra de Outes - A Coruña | 61
(1 row)

now if I do a dump the line relative to this row is truncated and
after the field city field id_country is not dumped!!!
I tried to use the pg_dump of Postgres 7.3.2 and I have the same
error :-(
BTW I'm without backup

Any Idea?

Gaetano
Mendola

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mendola Gaetano 2003-07-04 23:13:03 Re: pg_dump trunc some rows
Previous Message Arumugam 2003-07-04 15:55:00 Pls. help me to clarify my doubts.