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.