Re: Upcoming PG re-releases

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: Upcoming PG re-releases
Дата
Msg-id Pine.LNX.4.58.0512071442040.21925@linuxworld.com.au
обсуждение исходный текст
Ответ на Re: Upcoming PG re-releases  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Upcoming PG re-releases  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Hi,

On Tue, 6 Dec 2005, Bruce Momjian wrote:

>
> Nice, updated.
>
> ---------------------------------------------------------------------------
>

I think my suggestion from the other day is useful also.

---

Omar Kilani and I have spent a few hours looking at the problem. For
situations where there is a lot of invalid encoding, manual fixing is just
not viable. The vim project has a kind of fuzzy encoding conversion which
accounts for a lot of the non-UTF8 sequences in UTF8 data. You can use vim
to modify your text dump as follows:

vim -c ":wq! ++enc=utf8 fixed.dump" original.dump

---

I think this is a viable option for people with a non-trivial amount of
data and don't see manual fixing or potentially losing data as a viable
option.

Thanks,

Gavin


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

Предыдущее
От: "Uwe C. Schroeder"
Дата:
Сообщение: Re: [GENERAL] 8.1, OID's and plpgsql
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: row is too big: size 8916, maximum size 8136