Re: upgrade 7.1.x -> 7.2.x - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: upgrade 7.1.x -> 7.2.x
Date
Msg-id 3D2F083F.3050103@commandprompt.com
Whole thread Raw
In response to upgrade 7.1.x -> 7.2.x  (Carl Anderson <candrsn@mindspring.com>)
List pgsql-general
Hello,

  Why not just open the dump in VI or Joe (Joe doesn't handle huge files
well), and do a search an replace?

Carl Anderson wrote:

>
> I am having problems upgrading from 7.1.2 to 7.2.1
>
> are there any tools that account for the char handling change from 7.1
> to 7.2
>
>    in 7.1.3     select 'hello'::char;   works
>
>    in 7.2.1     select 'hello'::char;   fails
>
> I am ambivalent to the dataype change
> all I need is a tool that converts datatype char unmodified to varchar
> unmodified
> but leaves char modified (char(1), char(2)) alone.
>
> possibly someone who has dealt with this has a hacked pg_dump.
>
> C.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html




pgsql-general by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: PostgreSQL in mission-critical system
Next
From: "Joshua D. Drake"
Date:
Subject: Re: about middleware over postgreSQL....