Re: tsearch_core patch: permissions and security issues - Mailing list pgsql-hackers

From Tom Lane
Subject Re: tsearch_core patch: permissions and security issues
Date
Msg-id 19447.1181851007@sss.pgh.pa.us
Whole thread Raw
In response to Re: tsearch_core patch: permissions and security issues  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: tsearch_core patch: permissions and security issues
List pgsql-hackers
Teodor Sigaev <teodor@sigaev.ru> writes:
> Tom Lane wrote:
>> Teodor Sigaev <teodor@sigaev.ru> writes:
>>> The reason to save SQLish interface to dictionaries is a simplicity of 
>>> configuration. Snowball's stemmers are useful as is, but ispell dictionary 
>>> requires some configuration action before using.
>> 
>> Yeah.  I had been wondering about moving the dict_initoption over to the
>> configuration entry --- is that sane at all?  It would mean that

> It should be. Instances of ispell (and synonym, thesaurus) dictionaries are 
> different only in dict_initoption part, so it will be only one entry in 
> pg_ts_dict_template and several ones in pg_ts_dict.

No, I was thinking of still having just one pg_ts_dict catalog (no template)
but removing its dictinit field.  Instead, the init strings would be
stored with configuration mapping entries.

This would mean having to remember to provide the right option along
with the dictionary name when doing ALTER CONFIGURATION ADD MAPPING.
Not sure if that would be harder or easier to use than what you're
thinking of.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michael Paesold
Date:
Subject: Re: tsearch_core patch: permissions and security issues
Next
From: "Robert Wojciechowski"
Date:
Subject: Change sort order on UUIDs?