Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9AEE79FC1C4 for ; Thu, 9 Aug 2007 06:46:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 70724-01 for ; Thu, 9 Aug 2007 06:46:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.249]) by postgresql.org (Postfix) with ESMTP id 475A89FC184 for ; Thu, 9 Aug 2007 06:46:37 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so73619ana for ; Thu, 09 Aug 2007 02:46:35 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=IQDlJCD/A4Cpq9oNehuBtFS/ROt3LMOHGTDnKPlXOEi/Sfo2qzNEFmeOu+h1GdL8oQKPsLJPItoJtEOizY1OxRY4nc/3bPjLbZ19mDxIWtrIMQScQp+ZHfOFcxCWbU55Apy191wFw/7QfYQWilhb+miypiStOgll53im3wqpMmo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=tfKZIxJ0v6It18AEzFu+YTYZnyLzhBhfum7iU2yrh/kKFL/OQFFxJRKdE32uWFdAB+07u7MdeYIxFeBcRWTjPYZ6r9IyYrkS+Jrdt2U8TnSGACiUONlQAwjUAlHF1cSY546/yYCDFSrXiRhjDQzgXDxWkxKPdyAMH95u3M4SS1U= Received: by 10.100.108.11 with SMTP id g11mr1926291anc.1186652795123; Thu, 09 Aug 2007 02:46:35 -0700 (PDT) Received: by 10.100.195.18 with HTTP; Thu, 9 Aug 2007 02:46:35 -0700 (PDT) Message-ID: Date: Thu, 9 Aug 2007 15:16:35 +0530 From: "Rajesh Kumar Mallah" To: "postgres admin" Subject: not able to setup tsearch2 synonym dictionary MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/100 X-Sequence-Number: 26431 Hi , I am trying to setup a synonym dictionary setup using instructions in http://people.planetpostgresql.org/mha/index.php?/archives/118-Custom-synonym-dictionaries-in-tsearch2.html after following all the steps lexize is not doing the expected eg tradein_clients=# SELECT * from public.pg_ts_dict where dict_name='pg_dict'; -[ RECORD 1 ]---+------------------------------------------- dict_name | pg_dict dict_initoption | /opt/usr/local/pgsql/share/contrib/pg_dict dict_comment | pg-specific dictionary dict_init | syn_init(internal) dict_lexize | syn_lexize(internal,internal,integer) tradein_clients=# \!cat /opt/usr/local/pgsql/share/contrib/pg_dict postgresql postgres pgsql postgres postgre postgres tradein_clients=# \pset null NULL Null display is "NULL". tradein_clients=# select lexize('pg_dict','postgresql'),lexize('pg_dict','pgsql'); -[ RECORD 1 ] lexize | NULL lexize | NULL The expected result is lexize| {postgres} lexize| {postgres} can any one pls tell where things might have gone wrong? regds mallah