X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6BB7DD1BAD6 for ; Tue, 24 Feb 2004 14:25:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49524-07 for ; Tue, 24 Feb 2004 10:25:50 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 129ADD1B4AA for ; Tue, 24 Feb 2004 10:25:39 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i1OEPZQT023078; Tue, 24 Feb 2004 17:25:35 +0300 (MSK) Date: Tue, 24 Feb 2004 17:25:34 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Sam Barnett-Cormack Cc: Rajesh Kumar Mallah , pgsql-admin@postgresql.org Subject: Re: Tsearch1 problem In-Reply-To: Message-ID: References: <403B43A2.9040600@trade-india.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/341 X-Sequence-Number: 12515 On Tue, 24 Feb 2004, Sam Barnett-Cormack wrote: > On Tue, 24 Feb 2004, Oleg Bartunov wrote: > > > On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: > > > > > > > > Greetings, > > > > > > The function txt2txtidx of tsearch1 crashes the backend > > > in my installation when it is called with a text where '-' is > > > immediately followed by a number. > > > > example, please. Cut'n paste from psql console would be fine. > > Also, what's version of postgresql ? > > That would be what's below. > Ah, sorry :) Just tested on 7.4 and it works fine (as expected). qq=# select version(); version ------------------------------------------------------------------------ PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (1 row) qq=# SELECT txt2txtidx('Hello A-1'); txt2txtidx ------------------- '1' 'a-1' 'hello' Also, I run test on 7.3.3 qq=# select version(); version --------------------------------------------------------------- PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) qq=# SELECT txt2txtidx('Hello A-1'); txt2txtidx ------------------- '1' 'a-1' 'hello' (1 row) Everything is ok. I see your version of postgresql is outdated (you may upgrade at least to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! I don't remember 2.96 was officially released ! I'd recommend to think twice about your compiler. Don't know if postgresql supports unoffical releases. Oleg > > > Does any one has any solution for it? > > > > > > Regds > > > Mallah. > > > > > > > > > > > > tradein_clients=# SELECT version(); > > > +-----------------------------------------------------------+ > > > | version | > > > +-----------------------------------------------------------+ > > > | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 | > > > +-----------------------------------------------------------+ > > > (1 row) > > > > > > Time: 0.61 ms > > > tradein_clients=# SELECT txt2txtidx('Hello'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.72 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.72 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.64 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-A'); > > > +---------------+ > > > | txt2txtidx | > > > +---------------+ > > > | 'a-a' 'hello' | > > > +---------------+ > > > (1 row) > > > > > > Time: 0.92 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-1'); > > > server closed the connection unexpectedly > > > This probably means the server terminated abnormally > > > before or while processing the request. > > > The connection to the server was lost. Attempting reset: Failed. > > > !# > > > > > > > Regards, > > Oleg > > _____________________________________________________________ > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > Sternberg Astronomical Institute, Moscow University (Russia) > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > phone: +007(095)939-16-83, +007(095)939-23-83 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83