X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C665FD1D642 for ; Fri, 13 Feb 2004 14:28:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92683-07 for ; Fri, 13 Feb 2004 10:28:49 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id AAD53D1D5B0 for ; Fri, 13 Feb 2004 10:28:37 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i1DEScYJ010578; Fri, 13 Feb 2004 17:28:39 +0300 (MSK) Date: Fri, 13 Feb 2004 17:28:38 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Rajesh Kumar Mallah Cc: pgsql-admin@postgresql.org Subject: Re: co existance of tsearch V1 and V2 in same database. In-Reply-To: <402CC989.8000807@trade-india.com> Message-ID: References: <402908BB.1020904@trade-india.com> <402CC989.8000807@trade-india.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/202 X-Sequence-Number: 12376 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