Re: installing tsearch2

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: installing tsearch2
Date: 2011-10-19 14:12:58
Message-ID: 201110191712.59012.achill@matrix.gatewaynet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε:
> Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message erhaminus 2011-10-19 14:32:50 Composite type, DEFAULT, NOT NULL, REFERENCES
Previous Message Tom Lane 2011-10-19 13:46:55 Re: installing tsearch2