pg_dump trunc some rows

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема pg_dump trunc some rows
Дата
Msg-id 003801c3424b$e1030dc0$152aa8c0@GMENDOLA2
обсуждение исходный текст
Список 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




В списке pgsql-admin по дате отправления:

Предыдущее
От: "Daniel Seichter"
Дата:
Сообщение: Re: Advantages and disadvantages of more than one dbserver
Следующее
От: "Mendola Gaetano"
Дата:
Сообщение: Re: pg_dump trunc some rows