Hi,

I have a problem with contrib/tsearch module. 

Simple select txt2txtidx('2-3') causes psql to crash with error:

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.


As I found out, this happens allways when in txt2txtidx input parameter occurs string with pattern: "number hyphen" or "hyphen number" !!!

pg 7.3 
redhat 7.3

Thanks, any idea ?



-----------------------------------------
Hot Mobiil - helinad, logod ja pilts�numid!
http://www.hot.ee

Sun,  8 Dec 2002 17:05:19 +0200
Argo Priivits <listdb@hot.ee>
7.3 txt2txtidx -> crash
Yes i found this bug earlier.
There is a patch for it in the mail archives.

Magnus

Argo Priivits <listdb@hot.ee> wrote:
> Hi,
> 
> I have a problem with contrib/tsearch module.
> 
> Simple select txt2txtidx('2-3') causes psql to crash with error:
> 
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> 
> 
> As I found out, this happens allways when in txt2txtidx input
> parameter occurs string with pattern: "number hyphen" or "hyphen
> number" !!!  
> 
> pg 7.3
> redhat 7.3
> 
> Thanks, any idea ?
> 


Sun, 8 Dec 2002 16:44:02 +0100
"Magnus Naeslund(f)" <mag@fbab.net>
Re: [GENERAL] 7.3 txt2txtidx -> crash
Argo,

this is known bug, please find patch from
http://www.sai.msu.su/~megera/postgres/gist/

  Regards,

     Oleg
On Sun, 8 Dec 2002, Argo Priivits wrote:

> Hi,
>
> I have a problem with contrib/tsearch module.
>
> Simple select txt2txtidx('2-3') causes psql to crash with error:
>
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
>
>
> As I found out, this happens allways when in txt2txtidx input parameter occurs string with pattern: "number hyphen" or "hyphen number" !!!
>
> pg 7.3
> redhat 7.3
>
> Thanks, any idea ?
>
>
>
> -----------------------------------------
> Hot Mobiil - helinad, logod ja piltsО©╫numid!
> http://www.hot.ee
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

	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


Mon, 9 Dec 2002 00:09:39 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: 7.3 txt2txtidx -> crash