Postgres Pro
Downloads
Home   >   mailing lists

Thread: ...

...

From
Ulf Mehlig
Date:
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
  ~~~~~~~~~~~~~~~~~~~~

Re: your mail

From
Bruce Momjian
Date:
>
> 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

Doesn't terminate 6.4, which should be released very, very soon.


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026