Re: Unicode Corruption and upgrading to 8.0.4. to 8.1

From: Howard Cole <howardnews(at)selestial(dot)com>
To: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unicode Corruption and upgrading to 8.0.4. to 8.1
Date: 2005-12-06 12:40:39
Message-ID: 439586C7.8060309@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-12-06 12:43:06 Re: massive performance hit when using "Limit 1"
Previous Message Karthik.S 2005-12-06 12:26:20 error in creating database