Received: from tycho.webline.dk (needles@[194.255.48.20]) by hub.org (8.9.1/8.9.1) with SMTP id RAA28048 for ; Thu, 14 Jan 1999 17:49:34 -0500 (EST) (envelope-from kar@webline.dk) Received: (qmail 26644 invoked from network); 14 Jan 1999 22:50:14 -0000 Received: from pm54-55.image.dk (HELO bohr.webline.dk) (194.234.60.247) by tycho.webline.dk with SMTP; 14 Jan 1999 22:50:14 -0000 Received: from webline.dk (localhost [127.0.0.1]) by bohr.webline.dk (8.8.8/8.8.8) with ESMTP id XAA07324 for ; Thu, 14 Jan 1999 23:34:02 +0100 Message-Id: <199901142234.XAA07324@bohr.webline.dk> Date: Thu, 14 Jan 1999 23:33:59 +0100 (CET) From: Kaare Rasmussen Reply-To: kar@webline.dk Subject: Error To: pgsql-general@postgreSQL.org In-Reply-To: MIME-Version: 1.0 Content-Type: TEXT/plain; CHARSET=US-ASCII 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.