pg_dump trunc some rows

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>, <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump trunc some rows
Date: 2003-07-04 16:31:57
Message-ID: 003001c34249$c9ad9cf0$152aa8c0@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-bugs

Hi all,
I have a DB 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!!!

Any Idea?

Gaetano
Mendola

Browse pgadmin-support by date

  From Date Subject
Next Message hahalin 2003-07-05 01:06:57 Error Message
Previous Message Jean-Michel POURE 2003-07-04 11:40:38 Re: RE : [GENERAL] pgAdmin III - Call for Translators

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-07-06 02:06:02 Re: problems...
Previous Message Shachar Shemesh 2003-07-04 14:17:58 case sensitivity