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--