pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: kar@webline.dk
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Error
Date: Mon, 15 Mar 1999 09:26:20 -0500 (EST)
Message-ID: <199903151426.JAA11984@candle.pha.pa.us> (raw)
In-Reply-To: <199901142234.XAA07324@bohr.webline.dk>

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



view thread (40+ messages)  latest in thread

Message-ID: <199903151426.JAA11984@candle.pha.pa.us>
Permalink:  ../199903151426.JAA11984@candle.pha.pa.us/
Also on:    postgresql.org/message-id/199903151426.JAA11984@candle.pha.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: maillist@candle.pha.pa.us, kar@webline.dk
  Subject: Re: [GENERAL] Error
  In-Reply-To: <199903151426.JAA11984@candle.pha.pa.us>
  References: <199901142234.XAA07324@bohr.webline.dk> <199903151426.JAA11984@candle.pha.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox