pg_dump trunc some rows
pg_dump trunc some rows
От:
"Mendola Gaetano" <mendola@bigfoot.com>
Дата:
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
Re: pg_dump trunc some rows
От:
"Mendola Gaetano" <mendola@bigfoot.com>
Дата:
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