Date: Thu, 18 Mar 2010 20:39:48 +0100 (CET)
From: =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= <imartinez@vectorsf.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
In-Reply-To: <13151.1268930806@sss.pgh.pa.us>
Subject: Re: Missing tsearch2 functions
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Thank you, Tom.

In fact what was failing was the creation of operators || and @@. Both used=
 the procedures concat, exectsq and rexectsq. So we can delete those operat=
or creation sentences.

----- Mensaje original -----
De: "Tom Lane" <tgl@sss.pgh.pa.us>
Para: "I=C3=B1igo Martinez Lasala" <imartinez@vectorsf.com>
CC: "pgsql-admin" <pgsql-admin@postgresql.org>
Enviados: Jueves, 18 de Marzo 2010 17:46:46 GMT +01:00 Amsterdam / Berl=C3=
=ADn / Berna / Roma / Estocolmo / Viena
Asunto: Re: [ADMIN] Missing tsearch2 functions=20

=3D?ISO-8859-1?Q?I=3DF1igo?=3D Martinez Lasala <imartinez@vectorsf.com> wri=
tes:
> We have adapted our schema in order to use tsearch2 from contrib folder
> for not having to rewrite all functions. We have cleaned most of old
> tsearch2 stuff, but some tsearch2 functions have dissapeared or at least
> we don't know how to invoke with postgres 8.4

> Theses functions are:
> exectsq
> rexectsq
> concat

None of those functions were ever meant to be invoked directly.  Use the
corresponding operators (@@ and ||) instead.

=09=09=09regards, tom lane