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.
