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