Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> > tsearch2 support is included in the 9.1 distribution. No need for any additional packages.
> > However, if you need to use the old functions, then you will have to install the
> > "Backwards-compatibility package for old contrib/tsearch2 API"
> > in <path_to_your_source>/contrib/tsearch2/
>
> > gmake
> > gmake install
> > then
> > psql -f <path_to_your_source>/contrib/tsearch2/sql/tsearch2.sql
>
> I think part of the OP's problem is that that advice is obsolete.
> In 9.1 you'd do "CREATE EXTENSION tsearch2", not feed a file to
> psql manually.
>
In his case, i think the dump from 8.3 will carry over those functions (the sql part) regardless.
> But the bigger picture is that pre-8.3 tsearch2 is obsolete and you
> should be trying to get rid of it not port it. See
> http://www.postgresql.org/docs/9.1/static/textsearch-migration.html
>
> regards, tom lane
>
--
Achilleas Mantzios