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"
Re: BUG #3413: character string or multibyte character to "char" |
Список | 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 по дате отправления: