Re: contrib/tsearch crashing postgresql 7.3 Stable

known problem and fixed in CVS
Get patch from http://www.sai.msu.su/~megera/postgres/gist/

Oleg
On Tue, 10 Dec 2002, Rajesh Kumar Mallah. wrote:

>
> Hi,
>
> tserach seems to have some problem with 7.3 Stable.
>
> test=# SELECT version();
>                           version
> -----------------------------------------------------------
>  PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
> test=# SELECT 'hello&world'::mquery_txt ;
>     mquery_txt
> -------------------
>  'hello' & 'world'
> (1 row)
>
> test=# SELECT 'hello4&world'::mquery_txt ;
>      mquery_txt
> --------------------
>  'hello4' & 'world'
> (1 row)
>
> test=# SELECT '4hello&world'::mquery_txt ;
>      mquery_txt
> --------------------
>  '4hello' & 'world'
> (1 row)
>
> test=# SELECT '4-hello&world'::mquery_txt ;
> 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.
> !#
>
> Can anyone replicate this problem ?
>
> In my case it happens consistently .
>
> Sadly i had to remove features depending on tsearch on my production
> website. So if the author takes notice of this and comment on solution
> i would be grateful.
>
> Otherwise 7.3 has been an amazing xperience till now.
>
> regds
> mallah.
>
>
>
>

    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