Re: contrib/tsearch crashing postgresql 7.3 Stable

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: contrib/tsearch crashing postgresql 7.3 Stable
Дата
Msg-id Pine.GSO.4.44.0212101636200.12232-100000@ra.sai.msu.su
обсуждение исходный текст
Ответ на contrib/tsearch crashing postgresql 7.3 Stable  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Ответы Re: contrib/tsearch crashing postgresql 7.3 Stable  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: contrib/tsearch crashing postgresql 7.3 Stable
Следующее
От: UltraMax
Дата:
Сообщение: ksqo