BUG #15566: can't insert money type
От | PG Bug reporting form |
---|---|
Тема | BUG #15566: can't insert money type |
Дата | |
Msg-id | 15566-83ad6aef2ac40aa7@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15566: can't insert money type
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15566 Logged by: Yusuke Sonomura Email address: yusuke.sonomura@jp.fujitsu.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
В списке pgsql-bugs по дате отправления: