Re: How to submit Tsearch V2 ?
От | Oleg Bartunov |
---|---|
Тема | Re: How to submit Tsearch V2 ? |
Дата | |
Msg-id | Pine.GSO.4.56.0307041638120.18602@ra.sai.msu.su обсуждение исходный текст |
Ответ на | Re: How to submit Tsearch V2 ? (Teodor Sigaev <teodor@sigaev.ru>) |
Список | pgsql-hackers |
Chris, what if we write, that old tsearch (v1) is deprecated in 7.4 and will be obsoleted in 7.5 and put tsearch-v1.tar.gz on our site. Oleg On Fri, 4 Jul 2003, Teodor Sigaev wrote: > I think with upgrade X.Y to X.Y+1 version of pgsql you need dump/restore all > databases, isn't it? > > So, for upgrading tsearch to V2 you need to do following: > 1 rename columns or typecast for type txtidx to tsvector, query_txt to tsquery > 2 rename function txt2txtidx to to_tsvector, ( may be to strip(to_tsvector()), > now tsvector has information for ranking ), trigger 'tsearch' isn't changed > 3 operator class (in create index command) gist_txtidx_ops to gist_tsvector_ops > 4 In queries: operator ## to @@ to_tsquery() and remove mquery_txt typecast > 5 If your locale of pgsql differ from 'C', execute before first query > select set_curcfg('default'); > > That's all. So upgrade from v1 to v2 isn't difficult. > > > > Christopher Kings-Lynne wrote: > >>>>>Out of interest - is it completely backwards compatible? > >>>> > >>>>unfortunately, no > >>> > >>>Then surely fully replacing tsearch will cause badness? > >> > >>I see, so are you suggesting separate dir for tsearch v2 ? > > > > > > Well, we use tserach 1 extensively. I want to be able to upgrade to 7.4 and > > have nothing break! > > > > If things will break, then you need to have a tsearch2 dir instead. > > > > Chris > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > 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
В списке pgsql-hackers по дате отправления: