Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6F8FD9FA0EE for ; Fri, 8 Dec 2006 11:56:05 -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 21733-03 for ; Fri, 8 Dec 2006 11:55:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.235]) by postgresql.org (Postfix) with ESMTP id ED70A9FA040 for ; Fri, 8 Dec 2006 11:55:40 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so523825nzh for ; Fri, 08 Dec 2006 07:55:39 -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=OKz1Tsfj+I0P07sI3dnMITcsRqT12yEioZhFT3nv5ZZdbXEx8QHTSZJXirwIJDsbF8BNCwmqYDdDjdUrt0cbIRqRUFbEh1LUQMYYZc+Z8NPCeTNkWTYQPd1OVjRr+bTKLomuTPp++AsXkYN48hRykzs9D0NMEI7JsQth10KwchI= Received: by 10.35.39.13 with SMTP id r13mr3664487pyj.1165593339464; Fri, 08 Dec 2006 07:55:39 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 07:55:39 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 21:25:39 +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/78 X-Sequence-Number: 23870 On 12/8/06, Oleg Bartunov wrote: > On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > > > Dear > > Oleg, > > In local development server. the old functions still exists in > > postgresql catalogs. But probably they are missing in the > > newer version of tsearch2.so that came with 8.2.0 . And hence > > postgres is crashing. I feel this should have been informed in the > > release notes. > > yes, you're right. Someone has offered help to write this but then > silently dissapeared, so we stay without release notes. Could you > summarise your experience and write them and we add them for 8.2.1 Sir, Dont you feel the incremental features should be available as upgrade patches. eg at one point of time i found that the = ( ts_vector , ts_vector) operator is missing in my database. later i had to manually create the operator by looking at the tsearch2.sql file of later releases. this is becuse tsearch2.sql (i think) was not runnable on database having older versions of tsearch2. yes i would summarise my experience but lemme know if the above is an issue. also do i need to change my application code ? (becoz the older function is not available) Warm Regds Mallah. > > Oleg >