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. 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
