Thread: pg_dump trunc some rows

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

On: Friday, July 04, 2003 6:46 PM   "myself" wrote:
> 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

I solved my problem exporting PGCLIENTENCODING=latin-1
I was running Postgres7.3.2 till few days ago without problems.


Regards
Gaetano Mendola