Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 970249F9FB2 for ; Fri, 8 Dec 2006 13:25:58 -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 93966-03 for ; Fri, 8 Dec 2006 13:25:50 -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 37D049F9C35 for ; Fri, 8 Dec 2006 13:25:51 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so461133pye for ; Fri, 08 Dec 2006 09:25:50 -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=Ja2hY/h+oCnYI6XTxvjg7m3aBI6Srn3iBzam2r6HDSddDx0h2YNfJxIEuCROx41/pJ/HdNx/SWf5eijp48rpiXnD44ztY6UZ87s64aFUWfiE05V4U3TtqE0YyUZ2Y2ga94fA9vhXP86Q23bA062G+mS54qrnvz62zrVKCE0fkdc= Received: by 10.35.89.10 with SMTP id r10mr3806650pyl.1165598750525; Fri, 08 Dec 2006 09:25:50 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 09:25:50 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 22:55:50 +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/86 X-Sequence-Number: 23878 On 12/8/06, Oleg Bartunov wrote: > On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > > > 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. > > some people use separate scheme contrib to load all contrib stuff, > so upgrading is much easy. > Sir, even with a seperate schema contrib one cannot drop the stuff in contrib and reload the new version . Becoz DROPs have to be cascaded to dependencies which contain real data. Eg index and table columns that depend on existence of TYPE. Regds Mallah.