Re(2): 7.0.3->7.1.2; pg_setlocale error

I haven't tried hard but I think it's the money data type from 7.0.3 dump
that caused it.

office=# select * from pp_payment;
NOTICE:  pg_setlocale(): 'LC_COLLATE=ˆ@' cannot be honored.
NOTICE:  pg_setlocale(): 'LC_CTYPE=°t!@?' cannot be honored.
NOTICE:  pg_setlocale(): 'LC_MONETARY=?Pi' cannot be honored.
office=# \d pp_payment
                                     Table "pp_payment"
  Attribute   |     Type      |                           Modifier
--------------+---------------+--------------------------------------------------------------
 id      | smallint      | not null
 rcptnum      | character(32) | not null
 customer     | character(16) |
 payment_type | character(32) |
 amount       | money         |
 balance      | integer       |
 active       | boolean       |
 rcptdate     | date          | default date(('current'::"timestamp" +
'00:00'::"interval"))


lamar.owen@wgcr.org writes:
>On Thursday 14 June 2001 11:34, pgsql-admin wrote:
>> I am trying to migrate from 7.0.3 to 7.1.2. I just got the
>> rpms from rawhide of redhat.
>
>> While loading the 7.0.3 dump_file to 7.1.2, I got these errors...
>>
>> ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql.so': No such file or
>> directory
>
>The current rawhide RPM's put the PL's in /usr/lib instead of
>/usr/lib/pgsql.
>The current PGDG RPM's put them in /usr/lib/pgsql, which is where the
>7.0.3
>RPMset put them.
>
>> NOTICE:  copy: line 1, pg_setlocale(): 'LC_COLLATE=Ȁ' cannot be
>honored.
>> NOTICE:  copy: line 1, pg_setlocale(): 'LC_CTYPE=°T0@X' cannot be
>honored.
>> NOTICE:  copy: line 1, pg_setlocale(): 'LC_MONETARY=X˜' cannot be
>honored.
>
>Now these are interesting.
>
>> Will it do harm to the data?
>
>Does it appear to have harmed your data?