Re: Import db from 8.1.3 to 8.3.1 - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Import db from 8.1.3 to 8.3.1
Date
Msg-id 20081023172927.GL3413@commandprompt.com
Whole thread Raw
In response to Re: Import db from 8.1.3 to 8.3.1  ("Otandeka Simon Peter" <sotandeka@gmail.com>)
Responses Re: Import db from 8.1.3 to 8.3.1  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Thu, Oct 23, 2008 at 08:24:12PM +0300, Otandeka Simon Peter wrote:
> Upgraded to 8.3.4 but am still getting the same error

So it isn't an error in 8.3.1.  But my bet is this:

>
> On Thu, Oct 23, 2008 at 4:35 PM, Andrew Sullivan <ajs@commandprompt.com> wrote

> >> I am trying to import db from 8.1.3 to 8.3.1 database however I get
> >> some characters  \x09\x09\x09\x09.

I expect that your problem is that 8.1 allowed some characters in that
you didn't want.  You probably need to use iconv to change those
characters to whatever are actually valid.

A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-general by date:

Previous
From: Collin Kidder
Date:
Subject: Re: Annoying Reply-To
Next
From: Jack Orenstein
Date:
Subject: Re: Postgres optimizer choosing wrong index