From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | umehlig(at)uni-bremen(dot)de (Ulf Mehlig) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: your mail |
Date: | 1998-11-04 23:03:10 |
Message-ID: | 199811042303.SAA18974@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe Pettus | 1998-11-05 01:47:46 | Something caught in the hose? |
Previous Message | Ulf Mehlig | 1998-11-04 22:44:24 |