The following psql session terminates with a backend problem. Does
somebody has an idea what went wrong? Can't use `group by' in views,
perhaps?
----------------------------------------------------------------------
=> create table xxx (
date1 date,
date2 date,
id smallint
);
CREATE
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196395 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196396 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196397 1
=> insert into xxx values ('01.01.1999', '15.01.1999', 1);
INSERT 196398 1
=> select date1, date2,
count(id)*(date2-date1) as q
from xxx
group by date1, date2;
date1| date2| q
----------+----------+--
01-01-1999|01-15-1999|56
(1 row)
=> create view xxx1 as
select date1, date2,
count(id)*(date2-date1) as q
from xxx
group by date1, date2;
CREATE
=> select * from xxx1;
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.
----------------------------------------------------------------------
I'm still using version 6.3.2
Many thanks,
Ulf
--
======================================================================
%%%%% Ulf Mehlig <ulf.mehlig@uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig@uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~
