Thread: yet another contrib module
Hello, June 1 is pretty close now, so I'm asking about yet another contrib module, pg_trgm which is rather mature and quite useful. Is't worth to put it into 7.5 contrib ? trgm - Trigram matching for PostgreSQL -------------------------------------- The pg_trgm contrib module provides functions and index classesfor determining the similarity of text based on trigrammatching. Also, we plan to submit schema support to contrib/tsearch2 this weekend. Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Sounds fine. --------------------------------------------------------------------------- Oleg Bartunov wrote: > Hello, > > June 1 is pretty close now, so I'm asking about yet another > contrib module, pg_trgm which is rather mature and quite useful. > Is't worth to put it into 7.5 contrib ? > > trgm - Trigram matching for PostgreSQL > -------------------------------------- > > The pg_trgm contrib module provides functions and index classes > for determining the similarity of text based on trigram > matching. > > Also, we plan to submit schema support to contrib/tsearch2 this weekend. > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
Oleg can You take a look at my diffs for tsearch2 (win32 build) ? Since the changes are trivial, can You make those changes and commit together with schema support? Regards ! ----- Original Message ----- From: "Bruce Momjian" <pgman@candle.pha.pa.us> To: "Oleg Bartunov" <oleg@sai.msu.su> Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org> Sent: Friday, May 28, 2004 9:23 PM Subject: Re: [HACKERS] yet another contrib module > > Sounds fine. > > -------------------------------------------------------------------------- - > > Oleg Bartunov wrote: > > Hello, > > > > June 1 is pretty close now, so I'm asking about yet another > > contrib module, pg_trgm which is rather mature and quite useful. > > Is't worth to put it into 7.5 contrib ? > > > > trgm - Trigram matching for PostgreSQL > > -------------------------------------- > > > > The pg_trgm contrib module provides functions and index classes > > for determining the similarity of text based on trigram > > matching. > > > > Also, we plan to submit schema support to contrib/tsearch2 this weekend. > > > > Regards, > > Oleg > > _____________________________________________________________ > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > Sternberg Astronomical Institute, Moscow University (Russia) > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > phone: +007(095)939-16-83, +007(095)939-23-83 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
On Sun, 30 May 2004, Darko Prenosil wrote: > Oleg can You take a look at my diffs for tsearch2 (win32 build) ? > Since the changes are trivial, can You make those changes and commit > together with schema support? Where we can get the diff ? > > Regards ! > > ----- Original Message ----- > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > To: "Oleg Bartunov" <oleg@sai.msu.su> > Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org> > Sent: Friday, May 28, 2004 9:23 PM > Subject: Re: [HACKERS] yet another contrib module > > > > > > Sounds fine. > > > > -------------------------------------------------------------------------- > - > > > > Oleg Bartunov wrote: > > > Hello, > > > > > > June 1 is pretty close now, so I'm asking about yet another > > > contrib module, pg_trgm which is rather mature and quite useful. > > > Is't worth to put it into 7.5 contrib ? > > > > > > trgm - Trigram matching for PostgreSQL > > > -------------------------------------- > > > > > > The pg_trgm contrib module provides functions and index classes > > > for determining the similarity of text based on trigram > > > matching. > > > > > > Also, we plan to submit schema support to contrib/tsearch2 this weekend. > > > > > > Regards, > > > Oleg > > > _____________________________________________________________ > > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > > Sternberg Astronomical Institute, Moscow University (Russia) > > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > > phone: +007(095)939-16-83, +007(095)939-23-83 > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Here: http://archives.postgresql.org/pgsql-hackers-win32/2004-05/msg00125.php I', not shure about Makefile changes, because I think Makefiles for contrib were changed since then. Regards ! On Monday 31 May 2004 04:48, Oleg Bartunov wrote: > On Sun, 30 May 2004, Darko Prenosil wrote: > > Oleg can You take a look at my diffs for tsearch2 (win32 build) ? > > Since the changes are trivial, can You make those changes and commit > > together with schema support? > > Where we can get the diff ? > > > Regards ! > > > > ----- Original Message ----- > > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > > To: "Oleg Bartunov" <oleg@sai.msu.su> > > Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org> > > Sent: Friday, May 28, 2004 9:23 PM > > Subject: Re: [HACKERS] yet another contrib module > > > > > Sounds fine. > > > > > > ----------------------------------------------------------------------- > > >--- > > > > - > > > > > Oleg Bartunov wrote: > > > > Hello, > > > > > > > > June 1 is pretty close now, so I'm asking about yet another > > > > contrib module, pg_trgm which is rather mature and quite useful. > > > > Is't worth to put it into 7.5 contrib ? > > > > > > > > trgm - Trigram matching for PostgreSQL > > > > -------------------------------------- > > > > > > > > The pg_trgm contrib module provides functions and index classes > > > > for determining the similarity of text based on trigram > > > > matching. > > > > > > > > Also, we plan to submit schema support to contrib/tsearch2 this > > > > weekend. > > > > > > > > Regards, > > > > Oleg > > > > _____________________________________________________________ > > > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > > > Sternberg Astronomical Institute, Moscow University (Russia) > > > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > > > phone: +007(095)939-16-83, +007(095)939-23-83 > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- TIP 1: subscribe and > > > > unsubscribe commands go to majordomo@postgresql.org > > > > > > -- > > > Bruce Momjian | http://candle.pha.pa.us > > > pgman@candle.pha.pa.us | (610) 359-1001 > > > + If your life is a hard drive, | 13 Roberts Road > > > + Christ can be your backup. | Newtown Square, Pennsylvania > > > > 19073 > > > > > ---------------------------(end of > > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe > > > commands go to majordomo@postgresql.org > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
Commited, thank you. I don't apply Makefile changes, becouse symbol links to pg_reg* functions will be resolved at runtime. And I did some small chenges in spell.c (add pg_wchar conversion to regcomp call). Darko Prenosil wrote: > Here: > http://archives.postgresql.org/pgsql-hackers-win32/2004-05/msg00125.php > > I', not shure about Makefile changes, because I think Makefiles for contrib > were changed since then. > > Regards ! > > On Monday 31 May 2004 04:48, Oleg Bartunov wrote: > >>On Sun, 30 May 2004, Darko Prenosil wrote: >> >>>Oleg can You take a look at my diffs for tsearch2 (win32 build) ? >>>Since the changes are trivial, can You make those changes and commit >>>together with schema support? >> >>Where we can get the diff ? >> >> >>>Regards ! >>> >>>----- Original Message ----- >>>From: "Bruce Momjian" <pgman@candle.pha.pa.us> >>>To: "Oleg Bartunov" <oleg@sai.msu.su> >>>Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org> >>>Sent: Friday, May 28, 2004 9:23 PM >>>Subject: Re: [HACKERS] yet another contrib module >>> >>> >>>>Sounds fine. >>>> >>>>----------------------------------------------------------------------- >>>>--- >>> >>>- >>> >>> >>>>Oleg Bartunov wrote: >>>> >>>>>Hello, >>>>> >>>>>June 1 is pretty close now, so I'm asking about yet another >>>>>contrib module, pg_trgm which is rather mature and quite useful. >>>>>Is't worth to put it into 7.5 contrib ? >>>>> >>>>>trgm - Trigram matching for PostgreSQL >>>>>-------------------------------------- >>>>> >>>>>The pg_trgm contrib module provides functions and index classes >>>>>for determining the similarity of text based on trigram >>>>>matching. >>>>> >>>>>Also, we plan to submit schema support to contrib/tsearch2 this >>>>>weekend. >>>>> >>>>>Regards, >>>>>Oleg >>>>>_____________________________________________________________ >>>>>Oleg Bartunov, sci.researcher, hostmaster of AstroNet, >>>>>Sternberg Astronomical Institute, Moscow University (Russia) >>>>>Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ >>>>>phone: +007(095)939-16-83, +007(095)939-23-83 >>>>> >>>>>---------------------------(end of >>>>>broadcast)--------------------------- TIP 1: subscribe and >>>>>unsubscribe commands go to majordomo@postgresql.org >>>> >>>>-- >>>> Bruce Momjian | http://candle.pha.pa.us >>>> pgman@candle.pha.pa.us | (610) 359-1001 >>>> + If your life is a hard drive, | 13 Roberts Road >>>> + Christ can be your backup. | Newtown Square, Pennsylvania >>> >>>19073 >>> >>> >>>>---------------------------(end of >>>>broadcast)--------------------------- TIP 1: subscribe and unsubscribe >>>>commands go to majordomo@postgresql.org >>> >>>---------------------------(end of broadcast)--------------------------- >>>TIP 3: if posting/reading through Usenet, please send an appropriate >>> subscribe-nomail command to majordomo@postgresql.org so that your >>> message can get through to the mailing list cleanly >> >> Regards, >> Oleg >>_____________________________________________________________ >>Oleg Bartunov, sci.researcher, hostmaster of AstroNet, >>Sternberg Astronomical Institute, Moscow University (Russia) >>Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ >>phone: +007(095)939-16-83, +007(095)939-23-83 >> >>---------------------------(end of broadcast)--------------------------- >>TIP 7: don't forget to increase your free space map settings > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Teodor Sigaev E-mail: teodor@sigaev.ru
Looking forward to see it work on WIN32 ! Regards ! On Monday 31 May 2004 15:32, Teodor Sigaev wrote: > Commited, thank you. > I don't apply Makefile changes, becouse symbol links to pg_reg* functions > will be resolved at runtime. And I did some small chenges in spell.c (add > pg_wchar conversion to regcomp call). > > Darko Prenosil wrote: > > Here: > > http://archives.postgresql.org/pgsql-hackers-win32/2004-05/msg00125.php > > > > I', not shure about Makefile changes, because I think Makefiles for > > contrib were changed since then. > > > > Regards ! > > > > On Monday 31 May 2004 04:48, Oleg Bartunov wrote: > >>On Sun, 30 May 2004, Darko Prenosil wrote: > >>>Oleg can You take a look at my diffs for tsearch2 (win32 build) ? > >>>Since the changes are trivial, can You make those changes and commit > >>>together with schema support? > >> > >>Where we can get the diff ? > >> > >>>Regards ! > >>> > >>>----- Original Message ----- > >>>From: "Bruce Momjian" <pgman@candle.pha.pa.us> > >>>To: "Oleg Bartunov" <oleg@sai.msu.su> > >>>Cc: "Pgsql Hackers" <pgsql-hackers@postgresql.org> > >>>Sent: Friday, May 28, 2004 9:23 PM > >>>Subject: Re: [HACKERS] yet another contrib module > >>> > >>>>Sounds fine. > >>>> > >>>>----------------------------------------------------------------------- > >>>>--- > >>> > >>>- > >>> > >>>>Oleg Bartunov wrote: > >>>>>Hello, > >>>>> > >>>>>June 1 is pretty close now, so I'm asking about yet another > >>>>>contrib module, pg_trgm which is rather mature and quite useful. > >>>>>Is't worth to put it into 7.5 contrib ? > >>>>> > >>>>>trgm - Trigram matching for PostgreSQL > >>>>>-------------------------------------- > >>>>> > >>>>>The pg_trgm contrib module provides functions and index classes > >>>>>for determining the similarity of text based on trigram > >>>>>matching. > >>>>> > >>>>>Also, we plan to submit schema support to contrib/tsearch2 this > >>>>>weekend. > >>>>> > >>>>>Regards, > >>>>>Oleg > >>>>>_____________________________________________________________ > >>>>>Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > >>>>>Sternberg Astronomical Institute, Moscow University (Russia) > >>>>>Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > >>>>>phone: +007(095)939-16-83, +007(095)939-23-83 > >>>>> > >>>>>---------------------------(end of > >>>>>broadcast)--------------------------- TIP 1: subscribe and > >>>>>unsubscribe commands go to majordomo@postgresql.org > >>>> > >>>>-- > >>>> Bruce Momjian | http://candle.pha.pa.us > >>>> pgman@candle.pha.pa.us | (610) 359-1001 > >>>> + If your life is a hard drive, | 13 Roberts Road > >>>> + Christ can be your backup. | Newtown Square, Pennsylvania > >>> > >>>19073 > >>> > >>>>---------------------------(end of > >>>>broadcast)--------------------------- TIP 1: subscribe and unsubscribe > >>>>commands go to majordomo@postgresql.org > >>> > >>>---------------------------(end of broadcast)--------------------------- > >>>TIP 3: if posting/reading through Usenet, please send an appropriate > >>> subscribe-nomail command to majordomo@postgresql.org so that your > >>> message can get through to the mailing list cleanly > >> > >> Regards, > >> Oleg > >>_____________________________________________________________ > >>Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > >>Sternberg Astronomical Institute, Moscow University (Russia) > >>Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > >>phone: +007(095)939-16-83, +007(095)939-23-83 > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 7: don't forget to increase your free space map settings > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings