Thread: Empty dictionary file when creating text search dictionary

Found this a couple of weeks back and just re-tested against head:

CREATE TEXT SEARCH DICTIONARY with an empty thesaurus file will crasch 
the backend.

To reproduce:
$ echo "" > $(pg_config --sharedir)/tsearch_data/thesaurus_empty.ths

Then use this thesaurus to create a text search dictionary:
CREATE TEXT SEARCH DICTIONARY thesaurus_astro (    TEMPLATE = thesaurus,    DictFile = thesaurus_empty,    Dictionary =
english_stem
);

It doesn't matter if the file is compleatly empty or just have comments. 
The result is the same.
Add a word:
$ echo "foo: bar" >> $(pg_config 
--sharedir)/tsearch_data/thesaurus_empty.ths

Creating the dictionary will now work.

Sorry  I have no patch to attach.

Regards,
roppert

This is a duplicate report and has been fixed by Tom already.

---------------------------------------------------------------------------

Robert Gravsj� wrote:
> Found this a couple of weeks back and just re-tested against head:
> 
> CREATE TEXT SEARCH DICTIONARY with an empty thesaurus file will crasch 
> the backend.
> 
> To reproduce:
> $ echo "" > $(pg_config --sharedir)/tsearch_data/thesaurus_empty.ths
> 
> Then use this thesaurus to create a text search dictionary:
> CREATE TEXT SEARCH DICTIONARY thesaurus_astro (
>      TEMPLATE = thesaurus,
>      DictFile = thesaurus_empty,
>      Dictionary = english_stem
> );
> 
> It doesn't matter if the file is compleatly empty or just have comments. 
> The result is the same.
> Add a word:
> $ echo "foo: bar" >> $(pg_config 
> --sharedir)/tsearch_data/thesaurus_empty.ths
> 
> Creating the dictionary will now work.
> 
> Sorry  I have no patch to attach.
> 
> Regards,
> roppert
> 
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +