From: | "Toru SHIMOGAKI" <shimogaki(dot)toru(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3413: character string or multibyte character to "char" |
Date: | 2007-06-26 10:59:11 |
Message-ID: | 200706261059.l5QAxBcx021764@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3413
Logged by: Toru SHIMOGAKI
Email address: shimogaki(dot)toru(at)oss(dot)ntt(dot)co(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Toru SHIMOGAKI | 2007-06-26 11:09:02 | Re: BUG #3413: character string or multibyte character to "char" |
Previous Message | Tom Lane | 2007-06-25 17:59:44 | Re: REVOKE CREATE does not work on default tablespace |