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: [EMAIL PROTECTED], 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: [EMAIL PROTECTED], 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly