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 6A288D1BABA for ; Wed, 21 Apr 2004 14:16:15 -0300 (ADT) 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 47073-06 for ; Wed, 21 Apr 2004 14:16:13 -0300 (ADT) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id DA515D1B88F for ; Wed, 21 Apr 2004 14:16:11 -0300 (ADT) Received: (qmail 32599 invoked from network); 21 Apr 2004 13:46:59 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 21 Apr 2004 13:46:59 -0000 Message-ID: <4086AC63.9050809@trade-india.com> Date: Wed, 21 Apr 2004 22:46:19 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "'pgsql-admin@postgresql.org'" Subject: set_curcfg('default') + tsearch1 call = postmaster crash Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/279 X-Sequence-Number: 13252 Greetings, in my database i have both tsearch1 and tsearch2 . the following sequence of commands lead to this repeatble problem . Any solution ? Regds mallah. Welcome to psql 7.4RC2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit tradein_clients=# SELECT version(); version -------------------------------------------------------------- PostgreSQL 7.4RC2 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) tradein_clients=# tradein_clients=# SELECT public.set_curcfg('default'); set_curcfg ------------ (1 row) tradein_clients=# SELECT 'herbal tea'::txtidx ## 'tea|herbal'; 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. !> !>