Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε: > Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general