Received: from cr168790-a.nmkt1.on.wave.home.com (IDENT:root@cr168790-a.nmkt1.on.wave.home.com [24.112.63.230]) by hub.org (8.9.1/8.9.1) with ESMTP id AAA19417 for ; Thu, 14 Jan 1999 00:01:16 -0500 (EST) (envelope-from jproseve@arcavia.com) Received: from arcavia.com (jproseve@usjc064.uwaterloo.ca [129.97.122.80]) by cr168790-a.nmkt1.on.wave.home.com (8.8.7/8.8.7) with ESMTP id AAA07643; Thu, 14 Jan 1999 00:01:12 -0500 Sender: jproseve@cr168790-a.nmkt1.on.wave.home.com Message-ID: <369D7A93.EA0FC796@arcavia.com> Date: Thu, 14 Jan 1999 00:03:15 -0500 From: JP Rosevear Organization: Arcavia Software Ltd. X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org, "Jackson, DeJuan" Subject: More view problems Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Building on DeJuan's suggestion, we have arrived at the following code (using the extra view because from queries don't seem to allow sub queries): create view tab021temp as select fldkey as fldkey2, fld000 as fld000, fld001 as fld001 from tab000 group by fld001, fld000, fldkey2; create view tab021 as select count(1) as fldkey, a.fldkey2, a.fld000, a.fld001 from tab021temp a, tab021temp b where a.fld001 > b.fld001 or (a.fld001 = b.fld001 and a.fld000 > b.fld000) or a.fld000 = b.fld000 grouPQexec() -- Request was sent to backend, but backend closed the channel before rp by fld001, fld000, fldkey2; select * from tab021; This terminates in psql with the following error after the select statement is made: PQexec() -- Request was sent to backend, but backend closed the channel before r esponding. This probably means the backend terminated abnormally before or while pr ocessing the request. What is going on here? Multi level views seem to work if they are simple. Why is the connection being dropped? JDBC gives up a similar broken pipe error. -JP