From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Missing tsearch2 functions
Date: Thu, 18 Mar 2010 20:39:48 +0100 (CET)
Message-ID: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com> (raw)
In-Reply-To: <13151.1268930806@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com, tgl@sss.pgh.pa.us
Subject: Re: Missing tsearch2 functions
In-Reply-To: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox