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: Unicode Corruption and upgrading to 8.0.4. to 8.1
Date: 2005-12-02 14:02:55
Message-ID: 4390540F.5010404@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards,

Howard Cole
www.selestial.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-12-02 14:48:04 Re: postmaster / resolv.conf / dns problem
Previous Message Gevik 2005-12-02 14:00:15 Re: Table design