Re: Missing tsearch2 functions - Mailing list pgsql-admin

From Iñigo Martinez Lasala
Subject Re: Missing tsearch2 functions
Date
Msg-id 2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com
Whole thread Raw
In response to Re: Missing tsearch2 functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Missing tsearch2 functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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 operator creation sentences. 

----- Mensaje original -----
De: "Tom Lane" <tgl@sss.pgh.pa.us>
Para: "Iñigo 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ín / Berna / Roma / Estocolmo / Viena
Asunto: Re: [ADMIN] Missing tsearch2 functions

=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> writes:
> 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.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Abraham, Danny"
Date:
Subject: WHo is locking me?
Next
From: Tom Lane
Date:
Subject: Re: Missing tsearch2 functions