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: [EMAIL PROTECTED], 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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly