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

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-admin(at)postgresql(dot)org, lamar(dot)owen(at)wgcr(dot)org
Subject: Re(2): 7.0.3->7.1.2; pg_setlocale error
Date: 2001-06-17 13:56:48
Message-ID: fc.000f567200c49b69000f567200c49b69.c49b7b@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!(at)?' 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(dot)owen(at)wgcr(dot)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(at)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?

Browse pgsql-admin by date

  From Date Subject
Next Message Jie Liang 2001-06-17 18:08:09 need urgent help
Previous Message W. van den Akker 2001-06-17 12:51:34 Re: User rights