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