begin;
-- configuration
--update pg_ts_cfg set locale = 'QQ' where ts_name = 'default_english';
delete from pg_ts_cfg where ts_name = 'utf8';
insert into pg_ts_cfg values('utf8','default','el_GR.utf8');

-- dictionaries

DELETE FROM pg_ts_dict WHERE dict_name = 'el_ispell';
INSERT INTO pg_ts_dict
               (SELECT 'el_ispell', dict_init,
                       'DictFile="/tmp/greek.utf8/el_GR_utf8.dict",'
                       'AffFile="/tmp/greek.utf8/el.u8.aff",'
--		       'StopFile="/tmp/greek.utf8/greek.stop"'
			,dict_lexize
                FROM pg_ts_dict
                WHERE dict_name = 'ispell_template');

-- tokens to index
delete from pg_ts_cfgmap where ts_name = 'utf8';
insert into pg_ts_cfgmap values('utf8','nlhword','{el_ispell}');
insert into pg_ts_cfgmap values('utf8','nlword','{el_ispell}');
insert into pg_ts_cfgmap values('utf8','nlpart_hword','{el_ispell}');
end;