From: David Rugge <davidrugge@mindspring.com>
To: pgsql-sql@hub.org
Subject: postmaster dies on complicated views
Date: Thu, 17 Sep 1998 22:14:44 -0400
Message-ID: <l03102800b22770a89d74@[207.69.248.120]> (raw)
I've had a strange problem with viewing through anything but a basic view.
The view in question is defined as follows:
create view currentinfo
as
select pub_id, type, sum(price*ytd_sales), avg(price), avg(ytd_sales)
from titles
group by pub_id, type;
this is what happens when I do a select * from currentinfo:
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.
What does this message mean? Once I get this error, I have to quit and
relaunch psql before any other queries are successful. I think the problem
may be with the "sum(price*ytd_sales)" selection, since I tried another
query with multiplication in the select clause and it died too.
Thanks in advance,
-David Rugge
http://www.mindspring.com/~davidrugge/index.html
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-sql@postgresql.org
Cc: davidrugge@mindspring.com, pgsql-sql@hub.org
Subject: Re: postmaster dies on complicated views
In-Reply-To: <l03102800b22770a89d74@[207.69.248.120]>
References: <l03102800b22770a89d74@[207.69.248.120]>
* 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