From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Carl Anderson <candrsn(at)mindspring(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: upgrade 7.1.x -> 7.2.x |
Date: | 2002-07-12 16:47:59 |
Message-ID: | 3D2F083F.3050103@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2002-07-12 16:57:27 | Re: about middleware over postgreSQL.... |
Previous Message | Neil Conway | 2002-07-12 16:47:48 | Re: PostgreSQL in mission-critical system |