| 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: | Whole Thread | Raw Message | 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
| 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. |