Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2C2769F93A4 for ; Fri, 8 Dec 2006 08:20:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 16583-02 for ; Fri, 8 Dec 2006 08:20: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.181]) by postgresql.org (Postfix) with ESMTP id C878D9F9CB8 for ; Fri, 8 Dec 2006 08:20:42 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so425870pye for ; Fri, 08 Dec 2006 04:20:41 -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=dboyZ4UmQLKPgu3Vk/iZfY63bOI2/MKzWv4MOhYifyaDQI/7HfXWdgaQZoewDd3Njy0Hjejdv5J/z/46BnjlvJI4SShB87pyScmO7O5nA4eNJCoJVFaWT5Z/xtrpxUVa8LLFBnRixDWkneHZljEfPUKtXTiSD7fXpKwE2lF58mI= Received: by 10.35.80.20 with SMTP id h20mr5741541pyl.1165580441595; Fri, 08 Dec 2006 04:20:41 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 04:20:41 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 17:50:41 +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/70 X-Sequence-Number: 23862 On 12/8/06, Oleg Bartunov wrote: > On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > > > 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 ? > > from reference manual: > > CREATE FUNCTION rank_cd( > [ weights float4[], ] vector TSVECTOR, query TSQUERY, [ normalization int4 ] > ) RETURNS float4 > Dear Oleg, thanks for the prompt help. looks like we have to modify our application code. i would like to point out : In our Production Database \df public.rank_cd +--------+---------+------------------+-------------------------------------+ | Schema | Name | Result data type | Argument data types | +--------+---------+------------------+-------------------------------------+ | public | rank_cd | real | integer, tsvector, tsquery | | public | rank_cd | real | integer, tsvector, tsquery, integer | | public | rank_cd | real | tsvector, tsquery | | public | rank_cd | real | tsvector, tsquery, integer | +--------+---------+------------------+-------------------------------------+ (4 rows) In tsearch2.sql (with pgsql 8.2.0) $ grep "CREATE FUNCTION rank_cd" tsearch2.sql CREATE FUNCTION rank_cd(float4[], tsvector, tsquery) CREATE FUNCTION rank_cd(float4[], tsvector, tsquery, int4) CREATE FUNCTION rank_cd(tsvector, tsquery) CREATE FUNCTION rank_cd(tsvector, tsquery, int4) This means first arguments have changed from integer to float4[] This means all the application code needs to be changed now :-/ > postgres=# SELECT name, rank_cd(name_vec,to_tsquery('hello') ) as rank from test where name_vec @@ to_tsquery('hello') ; > name | rank > -------------+------ > hello world | 0.1 > (1 row) > > or > > postgres=# SELECT name, rank_cd('{1,1,1,1}',name_vec,to_tsquery('hello') ) as rank from test where name_vec @@ to_tsquery('hello') ; > name | rank > -------------+------ > hello world | 1 > (1 row) BTW: above did not work for me i had to explicitly cast '{1,1,1,1}' to '{1,1,1,1}'::float4[] , is anything fishy with my database ? SELECT name, rank_cd('{1,1,1,1}'::float4[] ,name_vec,to_tsquery('hello') ) as rank from test where name_vec @@ to_tsquery('hello') ; ( PS: thanks for the nice tsearch software we have been using it since "pre tsearch" era. (openfts) ) Regds Mallah. > > > > > >> > >> Oleg > >> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: > >> > > > > 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 >