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
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 |