Re: your mail - Mailing list pgsql-general

From Bruce Momjian
Subject Re: your mail
Date
Msg-id 199811042303.SAA18974@candle.pha.pa.us
Whole thread Raw
In response to ...  (Ulf Mehlig <umehlig@uni-bremen.de>)
List pgsql-general
>
> 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

pgsql-general by date:

Previous
From: Ulf Mehlig
Date:
Subject: ...
Next
From: Christophe Pettus
Date:
Subject: Something caught in the hose?