pg_dump trunc some rows - Mailing list 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