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