BUG #3413: character string or multibyte character to "char"

Поиск
Список
Период
Сортировка
От Toru SHIMOGAKI
Тема BUG #3413: character string or multibyte character to "char"
Дата
Msg-id 200706261059.l5QAxBcx021764@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3413: character string or multibyte character to "char"  (Toru SHIMOGAKI <shimogaki.toru@oss.ntt.co.jp>)
Re: BUG #3413: character string or multibyte character to "char"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3413
Logged by:          Toru SHIMOGAKI
Email address:      shimogaki.toru@oss.ntt.co.jp
PostgreSQL version: 8.2.4
Operating system:   Red Hat Enterprise Linux AS4
Description:        character string or multibyte character to "char"
Details:

When a character string or a multibyte character is inserted to "char"
column, no error occurs. Is this a bug? Should it be checked as "not single
character" in charin(), charrecv() and charout()?

Anyway, I can't find any spec descriptions in the following document;
  http://www.postgresql.org/docs/8.2/static/datatype-character.html

Best regards,


----

postgres=# select version();
                                              version
----------------------------------------------------------------------------
-----------------------
 PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-3)
(1 row)

postgres=# create table test(flag "char");
CREATE TABLE
postgres=# \d test
     Table "public.test"
 Column |  Type  | Modifiers
--------+--------+-----------
 flag   | "char" |

postgres=# insert into test values('a');
INSERT 0 1
postgres=# insert into test values('bb');
INSERT 0 1
postgres=# insert into test values('eeeee');
INSERT 0 1
postgres=# insert into test values('あ');
INSERT 0 1
postgres=# select * from test;
 flag
------
 a
 b
 e

(4 rows)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REVOKE CREATE does not work on default tablespace
Следующее
От: Toru SHIMOGAKI
Дата:
Сообщение: Re: BUG #3413: character string or multibyte character to "char"