Re: request a new feature in fuzzystrmatch

Sent from my iPad

On 18-May-2013, at 10:41, Liming Hu <dawninghu(at)gmail(dot)com> wrote:

> On Fri, May 17, 2013 at 9:39 PM, Atri Sharma <atri(dot)jiit(at)gmail(dot)com> wrote:
>>
>>
>> Sent from my iPad
>>
>> On 18-May-2013, at 10:00, Liming Hu <dawninghu(at)gmail(dot)com> wrote:
>>
>>> On 5/17/2013 9:10 PM, Atri Sharma wrote:
>>>> On Sat, May 18, 2013 at 9:27 AM, Liming Hu <dawninghu(at)gmail(dot)com> wrote:
>>>>> On 5/17/2013 12:39 PM, Liming Hu wrote:
>>>>>> On Fri, May 17, 2013 at 12:06 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>>>>>>>> Can we add Levenshtein-Damerau edit distance since it is used in
>>>>>>>> spelling checker
>>>>>>>> instead of levenshtein edit distance?
>>>>>>> Patches welcome! You, too, can be a PostgreSQL contributor.
>>>>>>>
>>>>>>> However, you will need to preserve the ability of users to use the old
>>>>>>> levenshtien algorithm as well, for backwards-compatibility. Shouldn't
>>>>>>> be hard, just add a new function called levenshtiend().
>>>>>> I am working on it, I will make it this weekend project.
>>>>>
>>>>> I have done that. and put the code at github:
>>>>> https://github.com/liminghu/fuzzystrmatch
>>>>>
>>>>> liming(at)liming-UX31A:~/Downloads/postgresql-9.1.9/contrib/fuzzystrmatch$
>>>>> sudo cp fuzzystrmatch.so
>>>>> /usr/lib/postgresql/9.1/lib/fuzzystrmatch.so
>>>>> liming(at)liming-UX31A:~/Downloads/postgresql-9.1.9/contrib/fuzzystrmatch$
>>>>> sudo /etc/init.d/postgresql restart
>>>>>
>>>>> * Restarting PostgreSQL 9.1 database server
>>>>>
>>>>> [ OK ]
>>>>>
>>>>>
>>>>> select dameraulevenshteinnocompatible('cta', 'cat',1,1,1,1);
>>>>> CREATE EXTENSION fuzzystrmatch;
>>>>>
>>>>> ********** Error **********
>>>>>
>>>>> ERROR: could not load library
>>>>> "/usr/lib/postgresql/9.1/lib/fuzzystrmatch.so":
>>>>> /usr/lib/postgresql/9.1/lib/fuzzystrmatch.so: undefined symbol:
>>>>> damerau_levenshtein_internal_noncompatible
>>>>>
>>>>> Any one can help me on this? Thanks.
>>>> The system is not able to find the required library, and I dont think
>>>> using cp to place the library is a very good idea.Did you run Make
>>>> Install after you added your work in the Makefile?
>>>
>>> I did not run make install. I am running a stable postgresql in my laptop, I do not
>>> want to reinstall everything, just want to try this contribution. I am afraid
>>> reinstall it will destroy my configurations, and databases, just do not want to mess up.
>>> did you see any thing wrong:
>>> https://github.com/liminghu/fuzzystrmatch/blob/master/fuzzystrmatch--1.0.sql
>>> https://github.com/liminghu/fuzzystrmatch/blob/master/fuzzystrmatch--unpackaged--1.0.sql
>>> https://github.com/liminghu/fuzzystrmatch/blob/master/fuzzystrmatch.c
>>> https://github.com/liminghu/fuzzystrmatch/blob/master/dameraulevenshtein.c
>>> https://github.com/liminghu/fuzzystrmatch/blob/master/
>>
>>
>>
>> You need not reinstall your entire database for installing/re installing an extension.Running make install from the extension's directory(after placing it in /contrib of a postgres database source directory) will install the extension in your current database without breaking anything.
>
> You mean:
> liming(at)liming-UX31A:~/Downloads/postgresql-9.1.9/contrib/fuzzystrmatch$
> make install
> ?
>
>

Yes,although,I would run make clean before running make install,just for ensuring that all runs well.

Regards,

Atri