From: | pgsql(at)gefi(dot)ml(dot)org |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | view problems |
Date: | 1998-08-22 12:48:35 |
Message-ID: | 35DEBE23.73A9@gefi.ml.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 1998-08-22 17:22:41 | DBD::Pg |
Previous Message | Bruce Momjian | 1998-08-22 12:42:16 | Re: [GENERAL] view problems |