Thread: co existance of tsearch V1 and V2 in same database.
Greetings, Can tsearch V1 and V2 exist in the same database simultaneously? I have read in past that its difficult , but is it possible for the desperate? regds mallah.
On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote:
>
>
> Greetings,
>
> Can tsearch V1 and V2 exist in the same database simultaneously?
> I have read in past that its difficult , but is it possible for the
> desperate?
quite peacefully, no problem
>
>
> regds
> mallah.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
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
Oleg Bartunov wrote: >On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote: > > > >>Greetings, >> >>Can tsearch V1 and V2 exist in the same database simultaneously? >>I have read in past that its difficult , but is it possible for the >>desperate? >> >> > >quite peacefully, no problem > > Thank You, thats a releif to know. regds mallah. > > >>regds >>mallah. >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 4: Don't 'kill -9' the postmaster >> >> >> > > 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 8: explain analyze is your friend > > >
On Fri, 13 Feb 2004, Rajesh Kumar Mallah wrote: > Oleg Bartunov wrote: > > >On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote: > > > > > > > >>Greetings, > >> > >>Can tsearch V1 and V2 exist in the same database simultaneously? > >>I have read in past that its difficult , but is it possible for the > >>desperate? > >> > >> > > > >quite peacefully, no problem > > > > > > Following error is got if installation of tsearch2 is attempted > in a database containing tsearch1 > > can u pls suggest? > > psql tsearch < tsearch2.sql > > SET > BEGIN > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "pg_ts_dict_pkey" for table "pg_ts_dict" > CREATE TABLE > ERROR: function "lexize" already exists with same argument types > ERROR: current transaction is aborted, commands ignored until end of > transaction block > I don't believe :) There were no lexize function in tsearch1. Please try on fresh database. > > > > > > > > > >>regds > >>mallah. > >> > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 4: Don't 'kill -9' the postmaster > >> > >> > >> > > > > 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 8: explain analyze is your friend > > > > > > > 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
Oleg Bartunov wrote: >On Fri, 13 Feb 2004, Rajesh Kumar Mallah wrote: > > > >>Oleg Bartunov wrote: >> >> >> >>>On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote: >>> >>> >>> >>> >>> >>>>Greetings, >>>> >>>>Can tsearch V1 and V2 exist in the same database simultaneously? >>>>I have read in past that its difficult , but is it possible for the >>>>desperate? >>>> >>>> >>>> >>>> >>>quite peacefully, no problem >>> >>> >>> >>> >>Following error is got if installation of tsearch2 is attempted >>in a database containing tsearch1 >> >>can u pls suggest? >> >>psql tsearch < tsearch2.sql >> >>SET >>BEGIN >>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>"pg_ts_dict_pkey" for table "pg_ts_dict" >>CREATE TABLE >>ERROR: function "lexize" already exists with same argument types >>ERROR: current transaction is aborted, commands ignored until end of >>transaction block >> >> >> > >I don't believe :) There were no lexize function in tsearch1. > Please try on fresh database. > > Apologies, it did work. regds mallah. > > >> >> >> >> >>> >>> >>>>regds >>>>mallah. >>>> >>>> >>>>---------------------------(end of broadcast)--------------------------- >>>>TIP 4: Don't 'kill -9' the postmaster >>>> >>>> >>>> >>>> >>>> >>> 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 8: explain analyze is your friend >>> >>> >>> >>> >>> > > 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 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 > > >