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?