Re: [GENERAL] Error

We have problems with aggregates in some views.  It is a know problem on
the TODO list.


> I got an error when accessing a view. The view looks like this:
>
> CREATE TABLE ar_contacts(
>     contact_seq         int,
>     update_date         date,
>     period              date,
>     paid                float,
>     sales               float,
>     last_date           date,
>     due                 float,
>     PRIMARY KEY (contact_seq, period)
> );
> CREATE VIEW ar_sales90_v AS
>     SELECT contact_seq, SUM(sales) AS sales90 FROM ar_contacts WHERE
>     period >= date(date_trunc('month','now'::date) - '2 month'::timespan)
>     GROUP BY contact_seq;
>
> If I
> SELECT * FROM ar_sales90_v WHERE contact_seq = 1;
> then everything is fine. I get what I expect:
>
> contact_seq|sales90
> -----------+-------
>           1|      6
> (1 row)
>
> If I do this:
> SELECT sales90 FROM ar_sales90_v WHERE contact_seq = 1;
> I get this result:
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally before or while
> processing the request. We have lost the connection to the backend, so
> further processing is impossible.  Terminating.
>
> The backend didn't die; I can restart psql and do my queries.
>
>
>


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