Received: from camel7.mindspring.com (camel7.mindspring.com [207.69.200.57]) by hub.org (8.8.8/8.8.8) with ESMTP id WAA10555 for ; Thu, 17 Sep 1998 22:34:18 -0400 (EDT) (envelope-from davidrugge@mindspring.com) Received: from [209.86.55.57] (user-38lcdpp.dialup.mindspring.com [209.86.55.57]) by camel7.mindspring.com (8.8.5/8.8.5) with ESMTP id WAA25590 for ; Thu, 17 Sep 1998 22:34:13 -0400 (EDT) Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Thu, 17 Sep 1998 22:14:44 -0400 To: pgsql-sql@hub.org From: David Rugge Subject: postmaster dies on complicated views 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