Sent from my iPad
On 18-May-2013, at 10:41, Liming Hu <dawnin...@gmail.com> wrote: > On Fri, May 17, 2013 at 9:39 PM, Atri Sharma <atri.j...@gmail.com> wrote: >> >> >> Sent from my iPad >> >> On 18-May-2013, at 10:00, Liming Hu <dawnin...@gmail.com> wrote: >> >>> On 5/17/2013 9:10 PM, Atri Sharma wrote: >>>> On Sat, May 18, 2013 at 9:27 AM, Liming Hu <dawnin...@gmail.com> wrote: >>>>> On 5/17/2013 12:39 PM, Liming Hu wrote: >>>>>> On Fri, May 17, 2013 at 12:06 PM, Josh Berkus <j...@agliodbs.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@liming-UX31A:~/Downloads/postgresql-9.1.9/contrib/fuzzystrmatch$ >>>>> sudo cp fuzzystrmatch.so >>>>> /usr/lib/postgresql/9.1/lib/fuzzystrmatch.so >>>>> liming@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@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
