upgrading tsearch2 (tsearch2.sql)

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "Lista Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: upgrading tsearch2 (tsearch2.sql)
Date: 2006-12-08 08:55:42
Message-ID: a97c77030612080055u7368358k6d206b993e840b38@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Morten Andersen 2006-12-08 09:42:27 Re: Recovery plan for DRDB setup - recovery tool
Previous Message ron 2006-12-08 07:36:40 Re: Problem starting up PostgreSQL 8.0 database service in Windows 2003 server