This was fixed in 6.5.
> 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
>
>
>
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026