Re: Upcoming PG re-releases - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Upcoming PG re-releases
Date
Msg-id 200512070437.jB74buw20492@candle.pha.pa.us
Whole thread Raw
In response to Re: Upcoming PG re-releases  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Upcoming PG re-releases
List pgsql-hackers
Exactly what does vim do that iconv does not?  Fuzzy encoding sounds
scary to me.

---------------------------------------------------------------------------

Gavin Sherry wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Replication on the backend
Next
From: Greg Stark
Date:
Subject: Re: [GENERAL] 8.1, OID's and plpgsql