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

From Alvaro Herrera
Subject Re: Import db from 8.1.3 to 8.3.1
Date
Msg-id 20081023173710.GH4845@alvh.no-ip.org
Whole thread Raw
In response to Re: Import db from 8.1.3 to 8.3.1  (Andrew Sullivan <ajs@commandprompt.com>)
Responses Re: Import db from 8.1.3 to 8.3.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Andrew Sullivan wrote:
> 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.

\x09 is a tab.  I think this behavior was changed in 8.3.something (made
it display as actual tabs instead of escaping them)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Postgres optimizer choosing wrong index
Next
From: ries van Twisk
Date:
Subject: Re: Annoying Reply-To