Re: tsearch - Regression tests fail

Hmm

just tried

select txt2txtidx('your text here....');

and it worked fine.

test=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

I'd suggest to try 7.2.1 (or 7.2.2 from CVS REL7_2_STABLE)

Oleg
On Mon, 29 Jul 2002, Markus Wollny wrote:

> Hi!
>
> You live, you learn - thanks for your help :) Version is PostgreSQL 7.2.
> The backend crashed when I do "select txt2txtidx(text) from article
> limit 1;". This is what I get when I do "gdb psql ./core":
>
> Core was generated by `postgres: postgres pcgames [local] SELECT
> '.
> Program terminated with signal 11, Segmentation fault.
> #0 0x40126853 in ?? ()
> #1 0x50e280fb in ?? ()
> #2 0x50e290a5 in ?? ()
> #3 0x080c90bd in ?? ()
> #4 0x080c9194 in ?? ()
> #5 0x080c9720 in ?? ()
> #6 0x080c9a3a in ?? ()
> #7 0x080c9cd6 in ?? ()
> #8 0x080c9dba in ?? ()
> #9 0x080cfb77 in ?? ()
> #10 0x080c8099 in ?? ()
> #11 0x080d0978 in ?? ()
> #12 0x080c8159 in ?? ()
> #13 0x080c6fce in ?? ()
> #14 0x080c65f7 in ?? ()
> #15 0x0811796b in ?? ()
> #16 0x08116421 in ?? ()
> #17 0x081173d0 in ?? ()
> #18 0x080fd0f0 in ?? ()
> #19 0x080fc91f in ?? ()
> #20 0x080fbac9 in ?? ()
> #21 0x080fb635 in ?? ()
> #22 0x080d95bd in ?? ()
> #23 0x400cb7ee in ?? ()
>
> The relevant cell (first row of article, column text) contains this
> text: " Sie haben Spaъ an PC-Spielen? Und am Schreiben? Sie
> verfügen zudem über gute Deutsch- und Englischkenntnisse und
> streben eine Zukunft als Journalist an? Sie würden sich
> darüber freuen, mit Ihren Artikeln monatlich über eine Million
> Leser zu erreichen? Dann ist Ihr Platz vielleicht bei PC Games. Wer
> Interesse an einem Arbeitsplatz bei uns hat, findet alles Weitere in
> unserem Stellenangebot in der Special-Sektion - folgen Sie einfach dem
> Link unter dieser Meldung."
>
> Can you make something out of this?
>
> Regards,
>
> Markus
>
> > -----UrsprЭngliche Nachricht-----
> > Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> > Gesendet: Montag, 29. Juli 2002 18:01
> > An: Markus Wollny
> > Cc: pgsql-general(at)postgresql(dot)org; Oleg Bartunov
> > Betreff: Re: [GENERAL] tsearch - Regression tests fail
> >
> >
> > "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> writes:
> > > Platform is SuSE Linux 7.3 (Linux 2.4.10-64GB-SMP #1 SMP Tue Sep 25
> > > 12:36:09 GMT 2001 i686 unknown); I think it doesn't dump core, so I
> > > cannot provide a stack trace. In the logfile it just says: "DEBUG:
> > > server process (pid 22137) was terminated by signal 11". I
> > cannot find
> > > any core-files.
> >
> > Signal 11 is SIGSEGV on most Unixen (certainly including
> > Linux), so the
> > backend is certainly crashing. If you are not getting core files in
> > the $PGDATA/base/yourdbnumber/ directory, then I'd bet that the
> > postmaster is being started under "ulimit -c 0" conditions. Restart
> > it with "ulimit -c unlimited" environment and you should get a core.
> >
> > regards, tom lane
> >
>
> ---------------------------(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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83