Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F29D69FA173 for ; Tue, 12 Dec 2006 13:55:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 95680-08 for ; Tue, 12 Dec 2006 13:55:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 61D789F9357 for ; Tue, 12 Dec 2006 13:55:03 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so618634pye for ; Tue, 12 Dec 2006 09:55:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XAGlbndg4yVdqeds9k0iqBJNRKnBJD6Tt7hOFR8knMLDHluZrDJ6yXfUEZHFMGCune0uIRcgBr+Esqzg/bfXWh4OIhnjsPlIpzb9zkYUYGwnAiFRnlsJBUoFDmZc8XXulRdCVxnhlibqfKKqYROUggYB0apLaQBu4HVqBeltLto= Received: by 10.35.66.1 with SMTP id t1mr12724265pyk.1165946102785; Tue, 12 Dec 2006 09:55:02 -0800 (PST) Received: by 10.35.80.10 with HTTP; Tue, 12 Dec 2006 09:55:02 -0800 (PST) Message-ID: Date: Tue, 12 Dec 2006 23:25:02 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: query crashes 8.2.0 but not 8.1.5 Cc: "Lista Postgres" In-Reply-To: <5523.1165945708@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5523.1165945708@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/164 X-Sequence-Number: 23956 On 12/12/06, Tom Lane wrote: > "Rajesh Kumar Mallah" writes: > > below query crashes 8.2.0 > > > tradein_clients=> SELECT size from general.eyp_listing where size in > > (select distinct size from general.eyp_listing ) order by size limit > > 1; > > Already fixed. Hi, Can you *please* tell how to get the fix. i have installed 8.2 in devlopment server dunno when 8.2.1 would come. if i checkout from CVS i get 8.3dev which refuses to start with 8.2 initdb'ed directory. i tried patching subselect.c but failed. i am badly stuck. regds mallah. > > regards, tom lane >