Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 758E89F9EED for ; Fri, 8 Dec 2006 12:04:39 -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 33202-10 for ; Fri, 8 Dec 2006 12:04:32 -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.179]) by postgresql.org (Postfix) with ESMTP id 6C8C49F9386 for ; Fri, 8 Dec 2006 12:04:31 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so451614pye for ; Fri, 08 Dec 2006 08:04:30 -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=GxO9qmHjnaqpXH8/FLpXj3J2/hrhJ/JKsBBPNGoeMgzZS/iu5NwXRepa6Zb7c8i4Fu3x+l4FE4DWFk8WFevqC4hW5tHTkRKHLFkIRIko2zyiEQrPp8RMcUzntmkLPkOOEM8pBRfTZRtojjEwwfx4p86zOktSz+ip+zKFarydzhw= Received: by 10.35.18.4 with SMTP id v4mr6140009pyi.1165593870739; Fri, 08 Dec 2006 08:04:30 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 08:04:30 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 21:34:30 +0530 From: "Rajesh Kumar Mallah" To: "Oleg Bartunov" Subject: Re: tsearch2 problem rank_cd() (possibly) crashing postgres Cc: "Tom Lane" , 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: <5485.1165592831@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/80 X-Sequence-Number: 23872 On 12/8/06, Oleg Bartunov wrote: > On Fri, 8 Dec 2006, Tom Lane wrote: > > > Oleg Bartunov writes: > >> You need to read documentation ! rank_cd accepts the same args as rank() > >> function. > > > > Nonetheless, dumping core on bad input is not acceptable behavior ... > > we already resolved the situation. This is mostly problem of > missing release notes. Sir, if the old functions which are present in system catalogs and are missing in new tsearch2.so file and are not dropped from database then the database seems to be crashing when they are invoked. Should' upgrade scritps not drop the old functions. just a thought , this situation could arise in general not just tsearch2.so . Regds mallah. > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), > Sternberg Astronomical Institute, Moscow University, Russia > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(495)939-16-83, +007(495)939-23-83 >