zakkr@zf.jcu.cz writes:
>On Thu, Jun 14, 2001 at 11:34:06PM +0800, pgsql-admin wrote:
>
>> 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.
>
> This message is reported if standard setlocale(3) returns error. IMHO
>isn't PG problem, but something is bad in your system or PG setting.
>
> But why the copy call pg_setlocale() .. any trigger or function in
>domain
>integrity checking/setting in the table definition?
>
> Karel
according to the logs pg_dump was performing 'copy from stdin' and the
data has money data type.
I am wrong in my last email saying that it only affects one of our table
that
has money data type. I just saw the same error in the regression test.
What gives?
Sherwin
FROM "regression.diffs"
<CUT>
*** ./expected/int8.out Sat Jan 27 06:50:26 2001
--- ./results/int8.out Wed Jun 20 19:51:40 2001
***************
*** 111,116 ****
--- 111,119 ----
--
SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'),
to_char(q2, '9,999,999,999,999,999')
FROM INT8_TBL;
+ NOTICE: pg_setlocale(): 'LC_COLLATE=~HÆ^]^H@Ç^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_CTYPE=°t!@^XÕ^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_MONETARY=^XÕ^]^HhN&^H^P' cannot be honored.
to_char_1 | to_char | to_char
-----------+------------------------+------------------------
| 123 | 456
<CUT>
*** ./expected/numeric.out Sat Apr 8 03:17:42 2000
--- ./results/numeric.out Wed Jun 20 19:51:50 2001
***************
*** 698,703 ****
--- 698,706 ----
--
SELECT '' AS to_char_1, to_char(val, '9G999G999G999G999G999')
FROM num_data;
+ NOTICE: pg_setlocale(): 'LC_COLLATE=~HÆ^]^H@Ç^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_CTYPE=°t!@^XÕ^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_MONETARY=^XÕ^]^H| ²#^H^P' cannot be honored.
to_char_1 | to_char
-----------+------------------------
| 0
<CUT>
*** ./expected/rules.out Wed Dec 6 03:15:48 2000
--- ./results/rules.out Wed Jun 20 19:52:24 2001
***************
*** 52,57 ****
--- 52,60 ----
create rule rtest_emp_ins as on insert to rtest_emp do
insert into rtest_emplog values (new.ename, current_user,
'hired', new.salary, '0.00');
+ NOTICE: pg_setlocale(): 'LC_COLLATE=~HÆ^]^H@Ç^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_CTYPE=°t!@^XÕ^]^H^P' cannot be honored.
+ NOTICE: pg_setlocale(): 'LC_MONETARY=^XÕ^]^H¨P&^H^P' cannot be honored.
create rule rtest_emp_upd as on update to rtest_emp where new.salary !=
old.salary do
insert into rtest_emplog values (new.ename, current_user,
'honored', new.salary, old.salary);