not able to setup tsearch2 synonym dictionary

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "postgres admin" <pgsql-admin(at)postgresql(dot)org>
Subject: not able to setup tsearch2 synonym dictionary
Date: 2007-08-09 09:46:35
Message-ID: a97c77030708090246n7e8ec44bo1d3184eba8db742a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message smiley2211 2007-08-09 14:26:39 Delete COLUMN data
Previous Message pingu.freak 2007-08-09 09:36:59 Re: Specific questions about wraparound and vacuum