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 D651CD1C7F7 for ; Fri, 13 Feb 2004 20:03:34 +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 20126-05 for ; Fri, 13 Feb 2004 16:03:32 -0400 (AST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 4F7B3D1D362 for ; Fri, 13 Feb 2004 16:03:24 -0400 (AST) Received: (qmail 12849 invoked from network); 13 Feb 2004 20:06:25 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 13 Feb 2004 20:06:25 -0000 Message-ID: <402D2D94.6030308@trade-india.com> Date: Sat, 14 Feb 2004 01:33:32 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Oleg Bartunov Cc: pgsql-admin@postgresql.org Subject: Re: co existance of tsearch V1 and V2 in same database. References: <402908BB.1020904@trade-india.com> <402CC989.8000807@trade-india.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/206 X-Sequence-Number: 12380 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 > > >