view problems

Hi!

I want to create a view, but it crashes my backend (postgresql 6.3.2):

CREATE TABLE access
(
 host
char(200),
 ident
char(200),
 authuser
char(200),
 accdate
datetime,
 request
char(500),
 ttime
int2,
 statuts
int2,
 bytes
int4);
CREATE

insert into access values
('test','test','test','10-08-98','test','1','0','5555');
INSERT 36060304
1
select trim(host) as host,min(accdate),max(accdate),sum(bytes) from
access group by host;
host|min                          |max                          |
sum
----+-----------------------------+-----------------------------+----
test|Thu Oct 08 00:00:00 1998 CEST|Thu Oct 08 00:00:00 1998
CEST|5555
(1
row)

drop view
test2;
DROP
create view test2 as select trim(host) as host,accdate,bytes from
access;
CREATE
select * from
test2;
host|accdate
|bytes
----+-----------------------------+-----
test|Thu Oct 08 00:00:00 1998 CEST|
5555
(1
row)

drop view
test;
DROP
create view test as select trim(host) as
host,min(accdate),max(accdate),sum(bytes) from access group by host;
CREATE
select * from
test;
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
        This probably means the backend terminated abnormally before or
while processing the request.
EOF


Any hints?

Gerald Fischer