...

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
  ~~~~~~~~~~~~~~~~~~~~