Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA27554 for ; Sun, 6 Jun 1999 11:16:37 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA10202; Sun, 6 Jun 1999 11:16:01 -0400 (EDT) To: Chris Bitmead cc: pgsql-sql@hub.org Subject: Re: [SQL] Slashdot Query In-reply-to: Your message of Sun, 06 Jun 1999 20:59:12 +1000 <375A5480.B45FEEB3@bigfoot.com> Date: Sun, 06 Jun 1999 11:16:00 -0400 Message-ID: <10200.928682160@sss.pgh.pa.us> From: Tom Lane Chris Bitmead writes: > SELECT category.oid, category.title, category.image FROM story, > category* WHERE story.category = category.oid AND story.approved GROUP > BY category.oid, category.title, category.image ORDER BY min(datetime); > 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. This is a known problem --- see my pghackers email of a few days ago, "inherited GROUP BY is busted". regards, tom lane