| 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: | Whole Thread | Raw Message | 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?
| 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 |