Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B66B39F9EED for ; Fri, 8 Dec 2006 07:50:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 53854-08 for ; Fri, 8 Dec 2006 07:50:38 -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.176]) by postgresql.org (Postfix) with ESMTP id 5968B9F93A4 for ; Fri, 8 Dec 2006 07:50:38 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so422691pye for ; Fri, 08 Dec 2006 03:50:37 -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=erzjxKbj0Ajn6NJW/QLn/lteLAbZId5Ivs61qzqRMxyZ7idpDmD99KSSGYUBVGinLjgkRygRDwb4b3RZFGZzh/QMNmeUOFF8U15UCjfEM45vs/3Wi9YRgMM4q6B9EyvCDWgU5nvlTxriPjSVg5MNW8L8Y7+qNhwcv7rsG0x7oYg= Received: by 10.35.129.19 with SMTP id g19mr5667609pyn.1165578637219; Fri, 08 Dec 2006 03:50:37 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 03:50:37 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 17:20:37 +0530 From: "Rajesh Kumar Mallah" To: "Oleg Bartunov" Subject: Re: tsearch2 problem rank_cd() (possibly) crashing postgres Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/67 X-Sequence-Number: 23859 On 12/8/06, Oleg Bartunov wrote: > You need to read documentation ! rank_cd accepts the same args as rank() > function. Dear Oleg, Could you please elaborate a bit more if time permits. our application is old and it was working fine in 8.1.5. do i need to change the sql to use a different function ? > > Oleg > On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: >