Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2E1B09FA1A7 for ; Fri, 8 Dec 2006 04:55:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 21174-02 for ; Fri, 8 Dec 2006 04:55:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id A52CC9F93A4 for ; Fri, 8 Dec 2006 04:55:43 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so403014pye for ; Fri, 08 Dec 2006 00:55:42 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=R+R8xZLjar49F+NmvfgV3n5TJawsHvbEC8yLFjcQdw9jDxkpvEaRmCgYLYoGvrLXOrrTgoazXDtgwBvchLXYeil6uWp3IE52y0LU4LxBABsCs4fC8JvBIl8lPC+Ximnhtpc+RHZnz1fLv6mtlWNNsZHfLX1BxkgQzkdikJIrA3c= Received: by 10.35.81.1 with SMTP id i1mr5322202pyl.1165568142610; Fri, 08 Dec 2006 00:55:42 -0800 (PST) Received: by 10.35.80.8 with HTTP; Fri, 8 Dec 2006 00:55:42 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 14:25:42 +0530 From: "Rajesh Kumar Mallah" To: "Lista Postgres" Subject: upgrading tsearch2 (tsearch2.sql) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/58 X-Sequence-Number: 23850 Hi, We have been using tsearch for past couple of years. we feel that the script tsearch2.sql is only suitable for adding tsearch2 support to new databases which doesn not have it already. for databases that already have older version tsearch2 installed one has to manually tweak tsearch2.sql to get the new operators for functions installed. lot of parts needs to be commented out eg CREATE TABLE pg_ts_cfg etc and many object creation sql needs to be converted to CREATE OR REPLACE equivs. shouldnt' it is more cleaner ? running untsearch2.sql followed by tsearch2.sql is not an option as cascading drops , drops existing columns of database. Regds mallah.