upgrade 7.1.x -> 7.2.x

From: Carl Anderson <candrsn(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrade 7.1.x -> 7.2.x
Date: 2002-07-12 03:39:02
Message-ID: 20020712033902.GA475@vadose
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thirumoorthy Bhuvneswari 2002-07-12 04:35:04 Query Speed
Previous Message Lamar Owen 2002-07-12 03:37:56 Re: I am being interviewed by OReilly