From imartinez@vectorsf.com Thu Mar  18 16:41:52 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 01D6B632FB3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 13:41:52 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 77275-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 16:41:38 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 9C08B6338EB
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 13:41:38 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 0EBFC2480011
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 17:41:33 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id nBpah-Wf+OTZ for <pgsql-admin@postgresql.org>;
	Thu, 18 Mar 2010 17:41:29 +0100 (CET)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTP id E31512480006
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 17:41:28 +0100 (CET)
Subject: Missing tsearch2 functions
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
In-Reply-To: <1268903277.3827.1699.camel@ebony>
References: <4B9A6E8B.4050303@magneta.com.cy>
	<1268556612.3825.5025.camel@ebony>  <4B9DFD67.3050106@magneta.com.cy>
	<1268647021.3825.7469.camel@ebony>
	<7965A9DCF12CC14984420BCC37B1608F25AAFB989B@Elzar.grant.co.uk>
	<1268903277.3827.1699.camel@ebony>
Content-Type: multipart/alternative; boundary="=-1L3ozLPg3fJJaciofJF6"
Date: Thu, 18 Mar 2010 17:41:31 +0100
Message-ID: <1268930491.10034.63.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.037 tagged_above=-10 required=5 tests=AWL=0.561,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/123
X-Sequence-Number: 33922


--=-1L3ozLPg3fJJaciofJF6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi everybody.

We are trying to migrate a gforge (again) with postgres 8.1/2 to
postgres 8.4.

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

I've been unable to locate them at pg_catalog. I've not found reference
in tsearch2 documentation for exectsq and rexectsq. But concat should be
in place but it's missing!!
Any hint?

Thanks in advance. 

--=-1L3ozLPg3fJJaciofJF6
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
Hi everybody.<BR>
<BR>
We are trying to migrate a gforge (again) with postgres 8.1/2 to postgres 8.4.<BR>
<BR>
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<BR>
<BR>
Theses functions are:<BR>
exectsq<BR>
rexectsq<BR>
concat<BR>
<BR>
I've been unable to locate them at pg_catalog. I've not found reference in tsearch2 documentation for exectsq and rexectsq. But concat should be in place but it's missing!!<BR>
Any hint?<BR>
<BR>
Thanks in advance. 
</BODY>
</HTML>

--=-1L3ozLPg3fJJaciofJF6--




From tgl@sss.pgh.pa.us Thu Mar  18 17:10:29 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4BC1E6337F3
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 14:10:29 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 82551-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 17:10:13 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id F11D46321FD
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 14:10:14 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2IGkkWZ013152;
	Thu, 18 Mar 2010 12:46:47 -0400 (EDT)
To: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Missing tsearch2 functions 
In-reply-to: <1268930491.10034.63.camel@deimos> 
References: <4B9A6E8B.4050303@magneta.com.cy>
	<1268556612.3825.5025.camel@ebony>
	<4B9DFD67.3050106@magneta.com.cy>
	<1268647021.3825.7469.camel@ebony>
	<7965A9DCF12CC14984420BCC37B1608F25AAFB989B@Elzar.grant.co.uk>
	<1268903277.3827.1699.camel@ebony>
	<1268930491.10034.63.camel@deimos>
Comments: In-reply-to =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala
	<imartinez@vectorsf.com>
	message dated "Thu, 18 Mar 2010 17:41:31 +0100"
Date: Thu, 18 Mar 2010 12:46:46 -0400
Message-ID: <13151.1268930806@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.46 tagged_above=-10 required=5 tests=AWL=0.139,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/124
X-Sequence-Number: 33923

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



From imartinez@vectorsf.com Thu Mar  18 19:40:13 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D34F4632B5E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 16:40:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 72290-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 19:40:01 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 608EE63221D
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 16:40:01 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 7D93F248000E;
	Thu, 18 Mar 2010 20:39:56 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 9vk-1+hfeAyR; Thu, 18 Mar 2010 20:39:48 +0100 (CET)
Received: from hermes.vectorsf.com (hermes.vectorsf.com [10.70.4.30])
	by hermes.vectorsf.com (Postfix) with ESMTP id B8EC52480006;
	Thu, 18 Mar 2010 20:39:48 +0100 (CET)
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
X-Originating-IP: [87.223.125.51]
X-Mailer: Zimbra 5.0.20_GA_3127.RHEL4_64 (ZimbraWebClient - SAF3
	(Linux)/5.0.20_GA_3127.RHEL4_64)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201003/126
X-Sequence-Number: 33925

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



From tgl@sss.pgh.pa.us Thu Mar  18 19:49:01 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 53E3C632330
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 16:49:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 73616-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 18 Mar 2010 19:48:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id CBDBD63221D
	for <pgsql-admin@postgresql.org>; Thu, 18 Mar 2010 16:48:50 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2IJmn3D016235;
	Thu, 18 Mar 2010 15:48:49 -0400 (EDT)
To: =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= <imartinez@vectorsf.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Missing tsearch2 functions 
In-reply-to: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
References: <2087950908.632701268941188658.JavaMail.root@hermes.vectorsf.com>
Comments: In-reply-to =?utf-8?Q?I=C3=B1igo_Martinez_Lasala?=
	<imartinez@vectorsf.com>
	message dated "Thu, 18 Mar 2010 20:39:48 +0100"
Date: Thu, 18 Mar 2010 15:48:49 -0400
Message-ID: <16234.1268941729@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/127
X-Sequence-Number: 33926

=?utf-8?Q?I=C3=B1igo_Martinez_Lasala?= <imartinez@vectorsf.com> writes:
> 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.

Actually, it sounds to me like you might want to think about installing
the newer version's contrib/tsearch2 first.  See
http://www.postgresql.org/docs/8.4/static/textsearch-migration.html

In any case note that it's not expected that a dump containing the old
tsearch2 object definitions will load without any noise.  You should
expect some errors like this.  Just ignore the errors, unless they are
preventing loading some object that doesn't belong to the old tsearch2
module.

			regards, tom lane