char(n) default '' crashes server
От | Erich Stamberger |
---|---|
Тема | char(n) default '' crashes server |
Дата | |
Msg-id | Pine.LNX.3.94.990205200441.25113A-100000@gewi.kfunigraz.ac.at обсуждение исходный текст |
Ответы |
Re: [HACKERS] char(n) default '' crashes server
Re: [HACKERS] char(n) default '' crashes server Re: [HACKERS] char(n) default '' crashes server |
Список | pgsql-hackers |
Hi, I found a bug in 6.4.2 which seems to be related to the char(n) type and shows up if one assigns a zero-length default value. Here is an example: test=> create table t1 ( test-> str1 char(2) default '', <---- note this one test-> str2 text default '', test-> str3 text default '' test-> ); CREATE test=> insert into t1 values ('aa', 'string2', 'string3'); INSERT 91278 1 test=> insert into t1 (str3) values ('string3'); INSERT 91279 1 test=>test=> select * from t1; Backend message type 0x44 arrived while idle Backend message type 0x44 arrived while idle We have lost the connection to the backend, so further processing is impossible. Terminating. If the table is created as create table t1 ( str1 char(2) default ' ', str2 text default '', str3 text default '' ); the crash doesn't happen. Regards Erich
В списке pgsql-hackers по дате отправления: