Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7EDBD9FA1A7 for ; Thu, 7 Dec 2006 19:42:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 67563-03 for ; Thu, 7 Dec 2006 19:42:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F30029F938C for ; Thu, 7 Dec 2006 19:42:57 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kB7Ngu90021954; Thu, 7 Dec 2006 18:42:56 -0500 (EST) To: phillip.smith@weatherbeeta.com.au cc: pgsql-sql@postgresql.org Subject: Re: could not find pathkey item to sort In-reply-to: <008c01c71a4d$59b0a020$9b0014ac@wbaus090> References: <008c01c71a4d$59b0a020$9b0014ac@wbaus090> Comments: In-reply-to "Phillip Smith" message dated "Fri, 08 Dec 2006 09:16:29 +1100" Date: Thu, 07 Dec 2006 18:42:56 -0500 Message-ID: <21953.1165534976@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200612/80 X-Sequence-Number: 27036 "Phillip Smith" writes: > Since upgrading to PG 8.2, I'm getting this error on a nightly (bash) > script > ERROR: could not find pathkey item to sort I think this is a variant manifestation of the same bug already reported here: http://archives.postgresql.org/pgsql-hackers/2006-12/msg00284.php and fixed here: http://archives.postgresql.org/pgsql-committers/2006-12/msg00056.php Leastwise, it went away for me after applying that patch ... regards, tom lane