Re: Unicode Corruption and upgrading to 8.0.4. to 8.1 - Mailing list pgsql-general

From Howard Cole
Subject Re: Unicode Corruption and upgrading to 8.0.4. to 8.1
Date
Msg-id 439586C7.8060309@selestial.com
Whole thread Raw
In response to Re: Unicode Corruption and upgrading to 8.0.4. to 8.1  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
Hi Zlatko,

I shall give this a try later and let you know how I get on. Thank you
for responding.

Howard.

Zlatko Matic wrote:

> Have you tried to restore just schema first, then data?
> Greetings,
>
> Zlatko
>
>> Hi everyone, I have a problem with corrupt UTF-8 sequences in my
>> 8.0.4 dump which is preventing me from upgrading to 8.1 - which spots
>> the errors and refuses to import the data. Is there some SQL command
>> that I can use to fix or cauterise the sequences in the 8.0.4
>> database before dumping to 8.1?
>>
>> I think the problem arose using invalid client encodings - which were
>> not rejected prior to 8.1.
>>


pgsql-general by date:

Previous
From: Marcus Engene
Date:
Subject: Re: fts, compond words?
Next
From: Richard Huxton
Date:
Subject: Re: massive performance hit when using "Limit 1"