From mallah@trade-india.com Tue Feb 24 12:30:47 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B1977D1B9CB for ; Tue, 24 Feb 2004 12:30:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07839-02 for ; Tue, 24 Feb 2004 08:30:48 -0400 (AST) Received: from trade-india.com (unknown [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id 3AA78D1B989 for ; Tue, 24 Feb 2004 08:30:43 -0400 (AST) Received: (qmail 29466 invoked from network); 24 Feb 2004 12:29:22 -0000 Received: from system66.trade-india-local.com (HELO trade-india.com) (192.168.0.66) by system66.trade-india-local.com with SMTP; 24 Feb 2004 12:29:22 -0000 Message-ID: <403B43A2.9040600@trade-india.com> Date: Tue, 24 Feb 2004 17:59:22 +0530 From: Rajesh Kumar Mallah Organization: Infocom Network Limited User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Tsearch1 problem Content-Type: multipart/alternative; boundary="------------080705020701050806090504" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/338 X-Sequence-Number: 12512 This is a multi-part message in MIME format. --------------080705020701050806090504 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Greetings, The function txt2txtidx of tsearch1 crashes the backend in my installation when it is called with a text where '-' is immediately followed by a number. Does any one has any solution for it? Regds Mallah. tradein_clients=# SELECT version(); +-----------------------------------------------------------+ | version | +-----------------------------------------------------------+ | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 | +-----------------------------------------------------------+ (1 row) Time: 0.61 ms tradein_clients=# SELECT txt2txtidx('Hello'); +------------+ | txt2txtidx | +------------+ | 'hello' | +------------+ (1 row) Time: 0.72 ms tradein_clients=# SELECT txt2txtidx('Hello A'); +------------+ | txt2txtidx | +------------+ | 'hello' | +------------+ (1 row) Time: 0.72 ms tradein_clients=# SELECT txt2txtidx('Hello A-'); +------------+ | txt2txtidx | +------------+ | 'hello' | +------------+ (1 row) Time: 0.64 ms tradein_clients=# SELECT txt2txtidx('Hello A-A'); +---------------+ | txt2txtidx | +---------------+ | 'a-a' 'hello' | +---------------+ (1 row) Time: 0.92 ms tradein_clients=# SELECT txt2txtidx('Hello A-1'); 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. !# --------------080705020701050806090504 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
Greetings,

The function txt2txtidx of tsearch1 crashes the backend
in my installation when it is called with a text where '-'  is
immediately followed by a number.

Does any one has any solution for it?

Regds
Mallah.



tradein_clients=# SELECT version();
+-----------------------------------------------------------+
|                          version                          |
+-----------------------------------------------------------+
| PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 |
+-----------------------------------------------------------+
(1 row)

Time: 0.61 ms
tradein_clients=# SELECT txt2txtidx('Hello');
+------------+
| txt2txtidx |
+------------+
| 'hello'    |
+------------+
(1 row)

Time: 0.72 ms
tradein_clients=# SELECT txt2txtidx('Hello A');
+------------+
| txt2txtidx |
+------------+
| 'hello'    |
+------------+
(1 row)

Time: 0.72 ms
tradein_clients=# SELECT txt2txtidx('Hello A-');
+------------+
| txt2txtidx |
+------------+
| 'hello'    |
+------------+
(1 row)

Time: 0.64 ms
tradein_clients=# SELECT txt2txtidx('Hello A-A');
+---------------+
|  txt2txtidx   |
+---------------+
| 'a-a' 'hello' |
+---------------+
(1 row)

Time: 0.92 ms
tradein_clients=# SELECT txt2txtidx('Hello A-1');
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.
!#
--------------080705020701050806090504-- From oleg@sai.msu.su Tue Feb 24 13:41:21 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75A5BD1BAA2 for ; Tue, 24 Feb 2004 13:41:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 31062-02 for ; Tue, 24 Feb 2004 09:41:21 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id EA1FAD1B860 for ; Tue, 24 Feb 2004 09:41:10 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i1ODfCQT022486; Tue, 24 Feb 2004 16:41:12 +0300 (MSK) Date: Tue, 24 Feb 2004 16:41:12 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Rajesh Kumar Mallah Cc: pgsql-admin@postgresql.org Subject: Re: Tsearch1 problem In-Reply-To: <403B43A2.9040600@trade-india.com> Message-ID: References: <403B43A2.9040600@trade-india.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/339 X-Sequence-Number: 12513 On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: > > Greetings, > > The function txt2txtidx of tsearch1 crashes the backend > in my installation when it is called with a text where '-' is > immediately followed by a number. example, please. Cut'n paste from psql console would be fine. Also, what's version of postgresql ? > > Does any one has any solution for it? > > Regds > Mallah. > > > > tradein_clients=# SELECT version(); > +-----------------------------------------------------------+ > | version | > +-----------------------------------------------------------+ > | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 | > +-----------------------------------------------------------+ > (1 row) > > Time: 0.61 ms > tradein_clients=# SELECT txt2txtidx('Hello'); > +------------+ > | txt2txtidx | > +------------+ > | 'hello' | > +------------+ > (1 row) > > Time: 0.72 ms > tradein_clients=# SELECT txt2txtidx('Hello A'); > +------------+ > | txt2txtidx | > +------------+ > | 'hello' | > +------------+ > (1 row) > > Time: 0.72 ms > tradein_clients=# SELECT txt2txtidx('Hello A-'); > +------------+ > | txt2txtidx | > +------------+ > | 'hello' | > +------------+ > (1 row) > > Time: 0.64 ms > tradein_clients=# SELECT txt2txtidx('Hello A-A'); > +---------------+ > | txt2txtidx | > +---------------+ > | 'a-a' 'hello' | > +---------------+ > (1 row) > > Time: 0.92 ms > tradein_clients=# SELECT txt2txtidx('Hello A-1'); > 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. > !# > 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 From s.barnett-cormack@lancaster.ac.uk Tue Feb 24 14:06:21 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 79997D1BAA2 for ; Tue, 24 Feb 2004 14:06:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38441-08 for ; Tue, 24 Feb 2004 10:06:18 -0400 (AST) Received: from rebo.lancs.ac.uk (rebo.lancs.ac.uk [148.88.16.230]) by svr1.postgresql.org (Postfix) with ESMTP id F389ED1B4AA for ; Tue, 24 Feb 2004 10:06:11 -0400 (AST) Received: from mail.lancs.ac.uk ([148.88.1.10] helo=marl.lancs.ac.uk) by rebo.lancs.ac.uk with esmtp (Exim 4.30) id 1AvdCL-0004uW-U5; Tue, 24 Feb 2004 14:06:09 +0000 Received: from faa034000015.lancs.ac.uk ([148.88.81.14] helo=short.lancs.ac.uk) by marl.lancs.ac.uk with esmtp (Exim 3.36 #1) id 1AvdCL-0004DJ-00; Tue, 24 Feb 2004 14:06:09 +0000 Date: Tue, 24 Feb 2004 14:08:53 +0000 (GMT) From: Sam Barnett-Cormack X-X-Sender: sdb@short.lancs.ac.uk To: Oleg Bartunov Cc: Rajesh Kumar Mallah , "" Subject: Re: Tsearch1 problem In-Reply-To: Message-ID: References: <403B43A2.9040600@trade-india.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/340 X-Sequence-Number: 12514 On Tue, 24 Feb 2004, Oleg Bartunov wrote: > On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: > > > > > Greetings, > > > > The function txt2txtidx of tsearch1 crashes the backend > > in my installation when it is called with a text where '-' is > > immediately followed by a number. > > example, please. Cut'n paste from psql console would be fine. > Also, what's version of postgresql ? That would be what's below. > > Does any one has any solution for it? > > > > Regds > > Mallah. > > > > > > > > tradein_clients=# SELECT version(); > > +-----------------------------------------------------------+ > > | version | > > +-----------------------------------------------------------+ > > | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 | > > +-----------------------------------------------------------+ > > (1 row) > > > > Time: 0.61 ms > > tradein_clients=# SELECT txt2txtidx('Hello'); > > +------------+ > > | txt2txtidx | > > +------------+ > > | 'hello' | > > +------------+ > > (1 row) > > > > Time: 0.72 ms > > tradein_clients=# SELECT txt2txtidx('Hello A'); > > +------------+ > > | txt2txtidx | > > +------------+ > > | 'hello' | > > +------------+ > > (1 row) > > > > Time: 0.72 ms > > tradein_clients=# SELECT txt2txtidx('Hello A-'); > > +------------+ > > | txt2txtidx | > > +------------+ > > | 'hello' | > > +------------+ > > (1 row) > > > > Time: 0.64 ms > > tradein_clients=# SELECT txt2txtidx('Hello A-A'); > > +---------------+ > > | txt2txtidx | > > +---------------+ > > | 'a-a' 'hello' | > > +---------------+ > > (1 row) > > > > Time: 0.92 ms > > tradein_clients=# SELECT txt2txtidx('Hello A-1'); > > 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. > > !# > > > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University From oleg@sai.msu.su Tue Feb 24 14:25:52 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6BB7DD1BAD6 for ; Tue, 24 Feb 2004 14:25:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 49524-07 for ; Tue, 24 Feb 2004 10:25:50 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 129ADD1B4AA for ; Tue, 24 Feb 2004 10:25:39 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i1OEPZQT023078; Tue, 24 Feb 2004 17:25:35 +0300 (MSK) Date: Tue, 24 Feb 2004 17:25:34 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Sam Barnett-Cormack Cc: Rajesh Kumar Mallah , pgsql-admin@postgresql.org Subject: Re: Tsearch1 problem In-Reply-To: Message-ID: References: <403B43A2.9040600@trade-india.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/341 X-Sequence-Number: 12515 On Tue, 24 Feb 2004, Sam Barnett-Cormack wrote: > On Tue, 24 Feb 2004, Oleg Bartunov wrote: > > > On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: > > > > > > > > Greetings, > > > > > > The function txt2txtidx of tsearch1 crashes the backend > > > in my installation when it is called with a text where '-' is > > > immediately followed by a number. > > > > example, please. Cut'n paste from psql console would be fine. > > Also, what's version of postgresql ? > > That would be what's below. > Ah, sorry :) Just tested on 7.4 and it works fine (as expected). qq=# select version(); version ------------------------------------------------------------------------ PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (1 row) qq=# SELECT txt2txtidx('Hello A-1'); txt2txtidx ------------------- '1' 'a-1' 'hello' Also, I run test on 7.3.3 qq=# select version(); version --------------------------------------------------------------- PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) qq=# SELECT txt2txtidx('Hello A-1'); txt2txtidx ------------------- '1' 'a-1' 'hello' (1 row) Everything is ok. I see your version of postgresql is outdated (you may upgrade at least to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! I don't remember 2.96 was officially released ! I'd recommend to think twice about your compiler. Don't know if postgresql supports unoffical releases. Oleg > > > Does any one has any solution for it? > > > > > > Regds > > > Mallah. > > > > > > > > > > > > tradein_clients=# SELECT version(); > > > +-----------------------------------------------------------+ > > > | version | > > > +-----------------------------------------------------------+ > > > | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 | > > > +-----------------------------------------------------------+ > > > (1 row) > > > > > > Time: 0.61 ms > > > tradein_clients=# SELECT txt2txtidx('Hello'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.72 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.72 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-'); > > > +------------+ > > > | txt2txtidx | > > > +------------+ > > > | 'hello' | > > > +------------+ > > > (1 row) > > > > > > Time: 0.64 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-A'); > > > +---------------+ > > > | txt2txtidx | > > > +---------------+ > > > | 'a-a' 'hello' | > > > +---------------+ > > > (1 row) > > > > > > Time: 0.92 ms > > > tradein_clients=# SELECT txt2txtidx('Hello A-1'); > > > 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. > > > !# > > > > > > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings > > > > 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 From demolish@cwgsy.net Tue Feb 24 15:28:20 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C037BD1DD03 for ; Tue, 24 Feb 2004 15:28:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 69448-10 for ; Tue, 24 Feb 2004 11:28:22 -0400 (AST) Received: from CISX-Linux4.cisx.com (unknown [213.133.202.58]) by svr1.postgresql.org (Postfix) with ESMTP id AE92CD1DD65 for ; Tue, 24 Feb 2004 11:28:16 -0400 (AST) Received: from DEMOLITION ([192.168.100.22]) by CISX-Linux4.cisx.com (8.12.8/8.12.8) with SMTP id i1OFCXPc031313 for ; Tue, 24 Feb 2004 15:12:34 GMT Message-ID: <003001c3faea$a967f6c0$1664a8c0@DEMOLITION> From: "Donald Fraser" To: "[ADMIN]" References: <403B43A2.9040600@trade-india.com> Subject: Re: Tsearch1 problem Date: Tue, 24 Feb 2004 15:27:05 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/342 X-Sequence-Number: 12516 ----- Original Message ----- From: "Oleg Bartunov" To: "Sam Barnett-Cormack" Cc: "Rajesh Kumar Mallah" ; > I see your version of postgresql is outdated (you may upgrade at least > to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! > I don't remember 2.96 was officially released ! I'd recommend to think twice > about your compiler. Don't know if postgresql supports unoffical releases. > 2.96 is an official release under Redhat Linux version 2.4.7-10 (gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)) #1 Thu Sep 6 17:27:27 EDT 2001 I am also using postgres 7.3.4, but unfortunatley I am using tsearch2 so I cannot run the same tests. Donald Fraser From tgl@sss.pgh.pa.us Tue Feb 24 15:39:39 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 846D6D1E125 for ; Tue, 24 Feb 2004 15:39:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82008-04 for ; Tue, 24 Feb 2004 11:39:36 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id EEB3ED1E0DD for ; Tue, 24 Feb 2004 11:39:31 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1OFdaCr022429; Tue, 24 Feb 2004 10:39:36 -0500 (EST) To: Oleg Bartunov Cc: Sam Barnett-Cormack , Rajesh Kumar Mallah , pgsql-admin@postgresql.org Subject: Re: Tsearch1 problem In-reply-to: References: <403B43A2.9040600@trade-india.com> Comments: In-reply-to Oleg Bartunov message dated "Tue, 24 Feb 2004 17:25:34 +0300" Date: Tue, 24 Feb 2004 10:39:36 -0500 Message-ID: <22428.1077637176@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/343 X-Sequence-Number: 12517 Oleg Bartunov writes: > Also, I run test on 7.3.3 > Everything is ok. > I see your version of postgresql is outdated (you may upgrade at least > to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! There was at least one post-7.3 bug fix in tsearch, according to the CVS logs. Could this be it? 2002-12-06 00:15 momjian * contrib/tsearch/morph.c (REL7_3_STABLE): Thank you very much, you catch it :). This bug had a long life, because it exists if and only if locale of postmaster was a different from C (or ru_RU.KOI8-R). Please, apply patch for current CVS & 7.3.1 Magnus Naeslund(f) wrote: > Ok, I nailed the bug, but i'm not sure what the correct fix is. > Attached tsearch_morph.diff that remedies this problem by avoiding it. > Also there's a debug aid patch if someone would like to know how i > finally found it out :) > > There problem in the lemmatize() function is that GETDICT(...) returned > a value not handled (BYLOCALE). > The value (-1) and later used as an index into the dicts[] array. > After that everything went berserk stack went crazy somehow so trapping > the fault sent me to the wrong place, and every time i read the value it > was positive ;) > > So now i just return the initial word passed to the lemmatize function, > because i don't know what to do with it. Magnus Naeslund regards, tom lane From oleg@sai.msu.su Tue Feb 24 18:28:24 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B9878D1DD03 for ; Tue, 24 Feb 2004 18:28:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38188-05 for ; Tue, 24 Feb 2004 14:28:23 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2230D1DD65 for ; Tue, 24 Feb 2004 14:28:14 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i1OIS7QT026037; Tue, 24 Feb 2004 21:28:07 +0300 (MSK) Date: Tue, 24 Feb 2004 21:28:07 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Tom Lane Cc: Sam Barnett-Cormack , Rajesh Kumar Mallah , pgsql-admin@postgresql.org Subject: Re: Tsearch1 problem In-Reply-To: <22428.1077637176@sss.pgh.pa.us> Message-ID: References: <403B43A2.9040600@trade-india.com> <22428.1077637176@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/344 X-Sequence-Number: 12518 On Tue, 24 Feb 2004, Tom Lane wrote: > Oleg Bartunov writes: > > Also, I run test on 7.3.3 > > Everything is ok. > > I see your version of postgresql is outdated (you may upgrade at least > > to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! > > There was at least one post-7.3 bug fix in tsearch, according to the CVS > logs. Could this be it? Most probable ! > > 2002-12-06 00:15 momjian > > * contrib/tsearch/morph.c (REL7_3_STABLE): Thank you very much, you > catch it :). This bug had a long life, because it exists if and > only if locale of postmaster was a different from C (or > ru_RU.KOI8-R). > > Please, apply patch for current CVS & 7.3.1 > > Magnus Naeslund(f) wrote: > > Ok, I nailed the bug, but i'm not sure what the correct fix is. > > Attached tsearch_morph.diff that remedies this problem by > avoiding it. > > Also there's a debug aid patch if someone would like to know how > i > > finally found it out :) > > > > There problem in the lemmatize() function is that GETDICT(...) > returned > > a value not handled (BYLOCALE). > > The value (-1) and later used as an index into the dicts[] array. > > After that everything went berserk stack went crazy somehow so > trapping > > the fault sent me to the wrong place, and every time i read the > value it > > was positive ;) > > > > So now i just return the initial word passed to the lemmatize > function, > > because i don't know what to do with it. > > Magnus Naeslund > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > 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