Andy Colson wrote:
> Hi All,
>
> You knew it was coming....
>
>
> I tried doing a pg_dump --schema-only and restoring just that, but still
> got a bunch of errors (those above). If I clean that up of all the old
> text search stuff, and then run it, then do the data, will that work ok?
>
Further to this, I edited the schema, and created it ok, then dumped the
data across (after editing out all the tsearch stuff). So far so good.
However, my trigger failed:
CREATE TRIGGER fulltext_update BEFORE INSERT OR UPDATE ON times FOR EACH ROW EXECUTE PROCEDURE
tsearch2('vectors','remarks');
Looks like we renamed/removed the tsearch2 function? Is
setweight(to_tsvector()) the new way?
-Andy