7.3 txt2txtidx -> crash

Started by Argo Priivitsover 23 years ago3 messageshackersgeneral
Jump to latest
#1Argo Priivits
listdb@hot.ee
hackersgeneral

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

In reply to: Argo Priivits (#1)
hackersgeneral
Re: [GENERAL] 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:

Show quoted text

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 ?

#3Oleg Bartunov
oleg@sai.msu.su
In reply to: Argo Priivits (#1)
hackersgeneral
Re: 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