From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | yusuke(dot)sonomura(at)jp(dot)fujitsu(dot)com |
Subject: | BUG #15566: can't insert money type |
Date: | 2018-12-25 00:42:57 |
Message-ID: | 15566-83ad6aef2ac40aa7@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15566
Logged by: Yusuke Sonomura
Email address: yusuke(dot)sonomura(at)jp(dot)fujitsu(dot)com
PostgreSQL version: 10.3
Operating system: Solaris
Description:
-Issue
I can't INSERT numeric data to money column on Solaris.
And I can't understand what error message says. I think codeset should be
"UTF-8".
--How to reproduce
export LANG=ja_JP.UTF-8
initdb --encoding="UTF-8" --locale="ja_JP.UTF-8" --lc-collate="C"
--lc-ctype="C" --lc-messages="ja_JP.UTF-8" --lc-monetary="ja_JP.UTF-8"
--lc-numeric="ja_JP.UTF-8" --lc-time="ja_JP.UTF-8" -D inst1
pg_ctl start -D inst1
psql -d postgres<<EOF
CREATE TABLE test (a money);
INSERT INTO test values (2);
EOF
--Output I got
CREATE TABLE
2018-12-21 22:15:41.389 JST [8295] WARNING: could not determine encoding
for locale "ja_JP.UTF-8": codeset is "646"
WARNING: could not determine encoding for locale "ja_JP.UTF-8": codeset is
"646"
2018-12-21 22:15:41.390 JST [8295] ERROR: default conversion function for
encoding "" to "UTF8" does not exist
2018-12-21 22:15:41.390 JST [8295] STATEMENT: INSERT INTO test values
(2);
ERROR: default conversion function for encoding "" to "UTF8" does not
exist
--Output I expected
Just success of insertion.
--Installation I used
I got postgresql-10.3-S11.sparc-64.tar.bz2 from
https://www.postgresql.org/ftp/binary/v10.3/solaris/solaris11/sparc/
--Version
10.3
--Platform information
Solaris 11
SunOS s023g023 5.11 11.3 sun4v sparc sun4v
--my environment
Memory size: 4096 Megabytes
CPU 1649MHz*2
--my output of locale -a
C
POSIX
de_DE.UTF-8
en_US.UTF-8
es_ES.UTF-8
fr_FR.UTF-8
it_IT.UTF-8
ja_JP.UTF-8
ja_JP.eucJP
ko_KR.UTF-8
pt_BR.UTF-8
zh_CN.UTF-8
zh_TW.UTF-8
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-12-25 00:45:45 | Re: BUG #15565: truncate bug with tables which have temp table inherited |
Previous Message | Michael Paquier | 2018-12-25 00:11:11 | Re: BUG #15564: Setup sets wrong data type for value in Windows Registry |