From: | "Mendola Gaetano" <mendola(at)bigfoot(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump trunc some rows |
Date: | 2003-07-04 23:13:03 |
Message-ID: | 000801c34281$d1f95a60$152aa8c0@GMENDOLA2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | T.J. Hoo | 2003-07-05 02:11:55 | No such file or directory: ./configure |
Previous Message | Mendola Gaetano | 2003-07-04 16:46:55 | pg_dump trunc some rows |